MySQL Installing MySQL on Mac OS X

calendar Oct 26, 2009 · 1 min read  knowledgebase sql  · mysql  ·
Share on: linkedin copy
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.