安装mysql-connector-odbc-3.51.12-win32.msi;
1.找到《MySql.Data.dll》文件并拷贝到项目下;
2.在引用中添加MySql.Data.dll;
3.using MySql.Data;using MySql.Data.MySqlClient;
4.远程连接MYSQL数据库语句:
string myConnectionString = "server=192.168.1.10;user id=mysql; password=123456; database=mysql; pooling=false;charset=utf8;Allow Zero Datetime=True;";
如果连接不上 建议先试用控件测试一下数据源。
5.打开数据库:myConnectionString = "server=192.168.1.10;user id=mysql; password=123456; database=mysql; pooling=false;charset=utf8;Allow Zero Datetime=True;";
MySqlConnection mycn = new MySqlConnection(myConnectionString);
try{mycn.Open();MessageBox.Show("连接数据库成功","TEST");}
catch (Exception ex){MessageBox.Show(ex.Message.ToString()); }