我通过代码访问数据库出现报错: MySql.Data.MySqlClient.MySqlException: #28000Access denied for user 'name'@'ip' (using password: YES)
但是当我使用phpmyadmin网址登录的时候可以进入数据库
账号密码都正确
SQLUrl = "server = ip; Database = name; User Id = name; password = password";
MySqlConnection conn = new MySqlConnection(SQLUrl);
try
{
conn.Open();
print("更新验证连接成功!");
//设置查询命令(可自由输入sql查询语句)
MySqlCommand co = new MySqlCommand("select * from updateyoowavideo", conn);
//创建查询结果读取器,执行查询,并将结果返回给读取器
MySqlDataReader re = co.ExecuteReader();
if (re.HasRows)
{
while (re.Read())
{
//读取三列数据
LoadIdStr.Add(re[0] + "&" + re[1]);
}
}
re.Close();
}
catch(MySqlException e) { print(e); }