connecting to MySQL via Network

Question

hi guys..i am trying to connect to a database in the other computer which is in network...i should do it by using MySql..to do that i installed MySqlConnector for .Net in my pc and referenced it to my program and coded like below in try catch block
MySqlConnection connect = new MySqlConnection("server=pcname/Localhost;database=dbname;uid=a;pwd=b");
connect.Open();
Console.WriteLine("Baglanti Durumu : {0}",connect.State);
connect.Close();
and i am getting such an error "Unable to connect to any of the specified MySQL hosts "
so what can i do to get rid off that error...i am not sure about my connection string because i am working with MySql for the first time..and i am not sure if the settings are done correctly
can u help pls ? where is my mistake ?

Erdinc Kolukisa · Answer

hi sam..thanks for reply..i did what u said..right click to toolbox but i have nothing there..maybe it is because i make console application ?

Sam Hobbs · Answer

If you right-click in the Visual Studio Toolbox then select Choose Items... you can choolse additional items to be shown in the Toolbox and I think some of them are for MySQL. I don't remember what they are but I think I saw some.

Felipe Ramos · Answer

Check out this link http://dev.mysql.com/doc/workbench/en/wb-sql-editor.html the documentation is amazing. Try connecting to your sever or your local database using this tool and it should tell you the entire connection string once you are connected.

Erdinc Kolukisa · Answer

hi Felipe.thanks for the reply.but i didnt understand how i can use MySqlWorkBench.i downloaded something like that from mysql's site but i dont know how to use it..can u explain it or any other solution ? and i tried with the ip number of the pc that i try to connect but still same problem

Felipe Ramos · Answer

I would say try this instead MySqlConnection ( server=pcname;database=dbname;uid=a;pwd=b ); If you have the MySqlWorkbench running try connecting to the database to make sure the issue is not there and copy the connection string.