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: Salman Awan
Date: August 07, 2005 11:44AM

hi,

mglatts, thanks a lot for taking out this effort to write in such detail. your post was sufficent to solve this problem.

after gowing through other posts too, just wanted to summarize the steps for any newcomer

1. Login to MySql Administrator, select "Startup Variables" from menu, select "Security" Tab. check Use old passwords

2. Select "User Administration" from menu, select root user account, change password for root user (other than null)

3. Select "Service Control" from menu, press "Stop Service" button

4. Close MySql Administrator

5. Go to Windows > Start > Run, type services.msc press Ok. Services window will open

6. Select and right click on MySql service, Start service.

7. You are Done!, you can login to MySql Admin using the new password, and your php applications can now connect to MySql too using the new password.

*if you try to set back old password, problem may arise again. so... i guess... no choice other than changing login information to all existing Projects that connect to MySql Db.

Regards,
Salman Awan

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
Re: SOLUTION: "mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client"
August 07, 2005 11:44AM
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


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.