C# Connection to mySQL server

Rui Ruivo

Hello

I am trying to build a winform app with free mysql database.

I got the code from CodeProject, everything builds but the server adress doesnt appear to be right.

Anyone with more experience can help please ?

Please open the zip file, i was unable to past the sample code.

Best regards

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Hello Rui, go through below article you will understand,

https://www.c-sharpcorner.com/article/exploring-connection-in-ado-net/
Jignesh Kumar5y ago
Hi,

Your connection string sould be like this,

connectionString = "Data Source= DatabaseServerName; Integrated Security=true;Initial Catalog= YourDatabaseName; uid=YourUserName; Password=yourpassword; " providerName="System.Data.SqlClient""

You are missing provice name, Please add and check or you can give connectionstring in App.config file and you can read from config file

connectionString = "data source=" + server + ";" + "initial catalog=" +
database + ";" + "uid=" + uid + ";" + "Password=" + password + " ";

please refer this link for connectionstring,

https://www.c-sharpcorner.com/code/3379/connection-strings-in-web-config-file-using-asp-net.aspx
Rui Ruivo5y ago
I added the "%" on the distant access inside cPanel on the server and my direct ip but nothing yet.