Re: Cleartext plugin in MySQL Connector/NET

[Gabriela Martinez Sanchez]

MySQL 5.6 does not have support for old format password like 5.5 has.

You can do either of two things to rectify the situation

1. To allow the database to accept the oldstyle hash run
SET old_passwords=TRUE

2. Set a new password using the new hashing
SET old_passwords=FALSE

SET PASSWORD=PASSWORD('your_new_password_here')

The suggestion is to use the second method and use the new hashing algorithm because it makes your database access more secure.

Run the scripts from the server.