ÓÃ.netÁ´½Ómysqlʱ±¨´í?????? - .NET¼¼Êõ / C#

ÓÃ.net,ÔÚÁ¬½ÓmysqlÊDZ¨´í£º

unable to connect to any of the specified mysql hosts.


connectionString="server=ip;userid=*;password=*;database=*"

---

¶¥¡£¡£¡£

---

MYSQL ¹Ù·½ ÏÂÔØÒ»¸öÖмä¼þ.

---

<add name="ConStr" connectionString="server=192.169.1.115;database=miapsoft;uid=root;pwd=123456;charset=utf8" providerName="MySql.Data.MySqlClient"/>

ÕâÊÇÎÒÒÔÇ°ÓùýµÄ. charset=utf8 ÓÃÀ´ÅªÖÐÎÄÂÒÂëÎÊÌâ.

---

ding

---

ÒýÓÃ

MYSQL ¹Ù·½ ÏÂÔØÒ»¸öÖмä¼þ.

ÕÒµ½¡°Select a Mirror to Start Downloading - mysql-connector-net-6.2.3-src.zip¡±Õâ¸öûÓÐÏֳɵÄdllÎļþ£¬ÎÒ±àÒëʱ³ö´í£¬ÄãÓÐÏֳɵÄ6.2.3°æµÄMysql.Data.dllÂ𣿣¿

---

ûÓÐ °²×°ºÃÄǸö¾Í¿ÉÒÔÁË.

---

c# Á¬MysqlÐèÒª×Ô¼ºÐ´»òÊÇϸöÖмä¼þ

---

ÓкÎÄÑ,ÏÈÏÂÔØÒ»¸öMySQLDriverCS.dll
app.config:
<add name="mysql" connectionString="Data Source=mydb;Password=111111;User ID=root;Location=192.168.1.1" />
C# code:

using MySQLDriverCS;

string MySQLStr = ConfigurationManager.ConnectionStrings["mysql"].ConnectionString;
MySQLConnection MySQLConn = new MySQLConnection(xxxxxxxxxxxxxxxxxxx);
MySQLConn.Open();

MySQLCommand MyCmd = new MySQLCommand(@"select * from table",MySQLConn);
MyCmd.ExecuteNonQuery();