Re: SOLUTION "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"

[Anthony Hook]

I had problems following the guide too. It just wouldn't work for me. But here's the solution that worked for me in case it's useful for others.

In my case I already had a password for my root user to start with. So I used MySQL Administrator to blank it as explained in the guide. MySQL Administrator reported an error but apparently it had done its job - I just had to restart the apache/mysql servers (via control panel > administrative tools > services) for the new password to take effect. I verified this by logging back into MySQL Administrator with a blank password and that worked fine.

I then changed the root password back to what it was originally but the whole problem persisted. I tried several times (blanking and unblanking the password) but to no avail. I then changed the password to something different ("pass" in my case) and then everything started working! I then changed the password back to what it was originally, and it continued to work.

Switching to a temporary password definately seems to of done the trick for me.

Another thing that previously caught me out was I put the "old_passwords" line in the wrong section of my my.ini file, because there's more than one secion that has "port=3306" in it. So just make sure you add the "old_passwords" line after the occurance of "port=3306" that has the "# The TCP/IP Port the MySQL Server will listen on" comment, as mentioned in the guide!

So now phpMyAdmin is complaining about not being able to find the mbstring PHP extension, but that looks like a different issue now and looks like the password issue is now fixed!

Cheers, Ant