WampServer

Have everything setup, can access mysql directly from the command line with the password, but phpMyAdmin is coming up with this error. When I remove the password from MySQL, it opens up fine.

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

???

I meet the same problem.

anyone had any luck solving this?? i just set up wamp on a new computer. was going through and giving root user a pass and making the changes in the config.inc.php file like described in this faq: [www.en.wampserver.com] now i am gett the 1251 error. this is weird, and i think when i set this up the first time i remember doing something else to get this to work. and now the solution has COMPLETELY eluded me.... any help would be greatly appreciated.

SOLUTION:

This is not a WAMP problem but rather based on the fact that PHP4 still uses the old password mechanism of MySQL. This usually happens when your change your password. This is not a problem however. The full explanation is at:

[dev.mysql.com]

The instructions above is for a Linux server. For Windows it is almost the same - just a few changes here and there

WINDOWS walkthrough to fix problem
----------------------------------------------------
(just to make 100% sure.. you must TYPE in everything BETWEEN the "" quotation marks... but not the quotation marks itself)

1. Click Start -> Run and enter "cmd" to get to the command prompt.

2. Enter "cd \wamp\mysql\bin"

3. Enter "mysql -u root -p"

4. It will ask you for your database password. Enter it. You will now have a mysql> prompt

5. Enter "SET PASSWORD FOR root@localhost = OLD_PASSWORD('***********');"
Of course, REPLACE the ********* with your own password

6. Enter "exit" and close that window

6. Click on your WAMP icon (above the clock in the lower right corner of your screen)

7. Click on Config Files -> my.ini

8. Look for a section that says: [wampmysqld]. It is about a page down.

9. Add this line under the line that says port=3306

# set mysql to use old password mechanism
old_passwords

10. Here is an example of what the section in my.ini must look like
----example---
[wampmysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

# set mysql to use old password mechanism
old_passwords

#Path to installation directory. All paths are usually resolved relative to this.
basedir=c:/wamp/mysql

---- example-----

11. Save and close the file my.ini file

12. Click your WAMP icon -> MySQL -> Restart Service

13. If you did everything correctly your PHP4 will now connect to your MySQL database without any problems.

Wermer Avenant
[internet-knowhow.com]