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

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