MySql Password Authentication

Question

4.00/5 (1 vote)

See more:

C#

c# authentication with old password no longer supported use 4.1 style passwords

I am getting this error, I am using C# with mysql database.

Posted 19-Mar-13 21:32pm

Member 7985285

Add a Solution

Comments

Shubh Agrahari 20-Mar-13 3:40am

try correct password.....according to updated mode

[no name] 20-Mar-13 6:37am

You must provide the code that you have tried.

Marco Bertschi 20-Mar-13 7:07am

This is a MySQL specific error occured because of the password format of MySQL. Code wouldn't have helped out much.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Marco Bertschi · Answer 1 · 2013-03-20T01:06:00

This error comes with the newer versions of MySQL because they have changed the authentication mechanism with the newer versions. Either you upgrade the MySQL Server passwords to the new password format or set

old_passwords=1

in the seervers' my.ini - file. I'd say upgrading the password will be the better option, but you decide.

Additional information:
http://stackoverflow.com/questions/13706463/authentication-method-mysql-old-password-not-supported[^]
http://stackoverflow.com/questions/14960136/mysql-how-to-upgrade-all-client-programs-to-use-a-4-1-1[^]

cheers,
Marco Bertschi

MySql Password Authentication

1 solution

Solution 1

Add your solution here

Preview 0

MySql Password Authentication

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us