My database is MySQL 5.5.34, and I used MySQL Connector.NET version 6.5.4. After uninstalling 6.5.4 and installing version 6.6.6, I have problems with disconnecting. The corresponding code, which looks essentially like this, worked fine before the update.
MySqlConnection connection = new MySqlConnection("server=localhost;port=7654;uid=matt;pwd=password");
connection.Open(); // this results in the exception
This works fine when I do it in a simple console application, but does not work in my MS test
The exception that I get is:
MySql.Data.MySqlClient.MySqlException: "Authentication for host" localhost "for user" matte "using method" mysql_native_password "failed with mesage: Reading from stream failed"
Turning into an exception, the internal exception "Unable to read data from the transport connection: the established connection was interrupted by the software of your host machine."
I tried both VS 2010 and VS 2013. Same error for both.
Ideas?
source
share