Re: MySql – Authentication with old password no longer supported, use 4.1 style passwords

[Roberto Ezequiel Garcia Ballesteros]

Hi Andrew,

I don't recommend to have more than one Connector/NET version in the same application. What I mean is that you can have an independent application only used to set the new password (using Connector/NET previous version) and keep using your application with latest Connector/NET 6.6.x version.

Basically your new application will do the same as you do in Toad but without install it:

SET SESSION old_passwords=0;
SET PASSWORD=PASSWORD('YOURDATABASEPASSWORD');


Also you can define a new authentication mechanism to allow only the user change his own password (maybe you can request old password before change it or something similar).

Regards,
Roberto