How to connect C# Application to (MySQL) a remote database on cPanel or GoDaddy
This video is about How to connect Csharp (C#) Application to a remote database (MySql) on cPanel or another front end application
cPanel is nothing but a front-end application giving access to the hosting client configuration at the level of the hosting user.
// connection string
connString = “SERVER= address;PORT=3306;DATABASE=nameofdatabase;UID=uid;PASSWORD=password”;
// query
string query = “INSERT INTO `table` (`attr 1`, `attr 2`, `attr 3`) VALUES (‘value3’, ‘value2’, ‘value3’)”;