Creating a LAMP stack on AWS Free Tier

 https://shawn-shi.medium.com/how-to-host-a-lamp-web-application-server-on-aws-ec2-for-free-8f6fc61463ed#:~:text=Its%20free%20tier%20allows%20everyone,PHP)%20automatically%20pre%2Dinstalled.

Creating a Table in MySQL and Inserting some data

 MySqlCommand cmd = new MySqlCommand("CREATE TABLE MyTable (ID Integer, Data varchar(50))", conn);

cmd.ExecuteNonQuery();

cmd = new MySqlCommand("INSERT INTO MyTable (ID, Data) VALUES (1, 'May11 2021');", conn);
cmd.ExecuteNonQuery();

Visual Studio connecting to MySQL

 Video for installing the connector:

https://youtu.be/NLv8WV43TuA

Code Project example:

https://www.codeproject.com/Articles/43438/Connect-C-to-MySQL