MySQL Installing MySQL on Mac OS X

If you’re trying to use MySQL with phpMyAdmin, you’ve set up the phpMyAdmin’s config.inc.php, and you’re getting an error saying “Client does not support authentication protocol requested by server; consider upgrading MySQL client”, you need to set the password on the mysql command line using the OLD_PASSWORD(‘password’) routine.

For example:

tcsh: mysql

mysql> SET PASSWORD FOR root@localhost = OLD_PASSWORD(‘mypassword’);

via MySQL :: MySQL 5.0 Reference Manual :: 2.11 Installing MySQL on Mac OS X.