MySQL Forums
Forum List  »  Install & Repo

Re: SOLUTION "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Posted by: Anthony Hook
Date: July 29, 2005 11:25AM

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

Options: ReplyQuote

Written By
December 31, 2005 12:02AM
December 31, 2005 02:28AM
March 29, 2006 03:12AM
March 24, 2007 02:58PM
January 03, 2006 07:48AM
March 16, 2006 10:03AM
Re: SOLUTION "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
July 29, 2005 11:25AM
November 02, 2005 07:38AM
January 16, 2006 03:46PM
July 24, 2006 07:40AM
March 28, 2006 11:18PM
August 23, 2006 01:21PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.