MySQL Forums
Forum List  »  Install & Repo

SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
Posted by: Fernando Cabal
Date: November 07, 2005 10:46PM

Hello everyone , I lost quite sometime on this one

After upgrading to mysql 4.x , I created a database , added an user and set password and permissions.

Everytime I tried my script , I got mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Please do the following:

In /etc/my.cnf , add "old_passwords=1" to all sections (maybe only needed in the mysqld section but I did it everywhere)

stop and start the mysqld

reassing the password to the mysql user so it will be stored using the old format

Bingo!

Cheers


Fernando Cabal
http://www.interteldepot.com
(Cheap Domain Names & Hosting solutions)

Options: ReplyQuote


Subject
Written By
Posted
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
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
SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
November 07, 2005 10:46PM


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.