Web Host MySQL Exception: Authentication with old password no longer supported, use 4.1 style passwords.

Question

User887984496 posted

I had this issue for the longest time trying to connect to my MySQL database with my web host provider IPower.

I have a simple site where upon the user clicking a "submit" button I have asp.net code connecting to a database.  But I keep getting the following exception:

Exception Message:
Authentication with old password no longer supported, use 4.1 style passwords.

Answer 1

User887984496 posted

I have already found the solution to the exception I've had.  I only posted this error in case someone else runs into this, hopefully the solution I put that solved it for me also will help them.

In the phpMyAdmin I executed these two lines of code at once:

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

And with that I was then able to connect to the MySql database. :)