MySQL Installing MySQL on Mac OS X

October 26, 2009

If you’re trying to use MySQL with phpMyAdmin, you’ve set up the phpMyAdmin’s, 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.


Leave a Reply