unable to connect to any of the specified mysql hosts.

Bharathi Raja

static Globals() { GlobalInt = 1234; export_count = 0; Setshift = "Noon"; privilege = 0; Shifclose = 0; reportonly = 0; line1 = "HEADER"; line2 = ""; line3 = ""; line4 = ""; connectionstring = "Server=192.168.1.14;Port=3306;Database=chillum_timer;Uid=root;password=root;"; check1 = 0; check2 = 0; check3 = 0; close_status = 1; sclose_eid1 = "0"; dgridview_color = "#3a0000"; kop_print_11 = 1; kop_print_21 = 0; notifyIcon11 = 0; }

urgent please help me...

3 Replies

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

Sundaram Subramanian9y ago
Accepted answer
whats the issue is ??

1) Check the IP address, port number and database name and Id and Password.
0
mark toddy5y ago
In some of the ways, spacing and the order of parameters in the MySql connection string does matters.
So stick to the standard format
MysqlConn.ConnectionString = "Server=localhost;Port=1234;Database=My_Mysql_Database;Uid=root;Pwd=root;"
If the above connection string fails, try update your c# mysql connection string as shown below (without port variable as well):
MysqlConn.ConnectionString = "Server=localhost;Database=My_Mysql_Database;Uid=root;Pwd=root;"
Or, sometime the problem could be on your windows firewall, make sure your server allow access to all port associated with your mysql database.
http://net-informations.com/q/faq/mysql.html
0
Bharathi Raja9y ago
Thanks for reply idea.
+1