C# 在调用mysql.data.dll连接本地数据库时正常,连接远程Linux服务器上的mysql服务器报错
报错记录,当前连接字符串
System.Security.Authentication.AuthenticationException: Authentication to host ‘xxx.xxx.xxx.xx’ failed.
at MySql.Data.Common.Ssl.StartSSL(Stream& baseStream, Encoding encoding, String connectionString)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
<add key="dbString" value="server=localhost;port=3306;user=root;password=root; database=id3net" />
主机不支持ssl连接,那么就不使用ssl连接呗
解决思路,在连接字符串后面追加SSLMode=none即可。
<add key="dbString" value="server=localhost;port=3306;user=root;password=root; database=id3net;SslMode=none" />