my sql 连接

来源：百度知道 编辑：UC知道 时间：2024/06/22 16:28:28
MySQLConnection conn = null;
conn = new MySQLConnection(new MySQLConnectionString("127.0.0.1", "mysql", "root", "tv8610").AsString);
MySQLCommand command = new MySQLCommand("select * from db", conn);
MySQLDataAdapter da = new MySQLDataAdapter(command );
DataSet ds = new DataSet();
try
{
da.Fill(ds);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);

}

报错：MySQLDriverCS Exception: MySQLDriverCS Error: can't connect.Client does not support authentication protocol requested by server; consider upgrading MySQL client
请问那有问题了

你先去www.mysql.com下载一个驱动．
set adocon=Server.Createobject("adodb.connection")
创建实例
adocon.open"Driver={mysql};database=yourdatabase;uid=username;pwd=yourpassword;option=16386;"
连接数据库
Driver 表示你用的驱动在系统控制面板的ODBC里面查提到，和mssql一样的
database ＝＝＝你的数据库
uid=====你的用户名
pwd===密码
option===可以不要

//SqlDataReader 读取Sql数据
//Sql连接SqlCommand,非流,即使是重新凋用ExecuteReader(),他的数据依然是Open的那一刻.
String SqlText = "SELECT * FROM [Catalog]";
String ConnText = "server=(Local);database=MbSky;uid=sa;pwd=000000";
using (SqlConnection Conn = new SqlConnection(ConnText)) {
using (SqlCommand Rs = new SqlCommand(SqlText, Conn)) {
//打开连接
Conn.Open();
using (SqlDataReader RsData = Rs.ExecuteReader()) {
while (RsData.Read()) {
//书写一个列名为Id的值
Console.WriteLine(RsData[RsData.GetOrdinal("