mysql+.net2.0,无法连接

[kideve]

我安装了mysql的5.0.22版本，安装了MySqlDriverCS,引用了它，在使用的时候，open方法出错，抛出

MySQLDriverCS Exception: MySQLDriverCS Error: can't connect.Client does not support authentication protocol requested by server; consider upgrading MySQL client

我的代码部分：
public void Sq()
{
connstr = String.Format("server={0};user id={1}; password={2}; database={3};", "localhost", "root", "kideve", "test");

mysqlconn = new MySQLConnection(connstr);
// mysqlconn = new MySQLConnection(new MySQLConnectionString("localhost", "test", "root", "kideve").AsString);
mysqlconstate = mysqlconn.State.ToString();
mysqlconn.Open();

//进行初始化
}
谢谢

[fht800]

public static string GetConnectionString()
{
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.Add("server", "127.0.0.1");
builder.Add("database", "pas_system");
builder.Add("uid", "root");
builder.Add("pwd", "");
builder.Add("port", "3306");
builder.Add("pooling", "true");
builder.Add("compress", "false");
builder.Add("protocol", "tcp");
builder.Add("connection timeout", "20");
builder.Add("min pool size", "5");
builder.Add("max pool size", "100");
builder.Add("connection lifetime", "0");
return builder.ConnectionString;
//return ConfigurationManager.ConnectionStrings["Mysql"].ConnectionString;
}

[fht800]

public static MySqlConnection GetMysqlConnection()
{
MySqlConnection conn = new MySqlConnection(GetConnectionString());
return conn;
}

[fht800]

google: Mysql.Data.dll

[best8625]

UP...

[kideve]

谢谢大家，我积极继续做测试！

[kideve]

我自己先顶顶！

[kideve]

谢谢大家，我已经解决，使用fht800的方法，加了一些改变，谢谢~~