MySQL Crash Course
Subject:   mysql
Date:   2005-10-09 07:51:22
From:   wpjmurray
Response to: mysql

I ran into a similar problem with PHP and MySQL on my Mac. Apparently the current version of MySQL uses a different password scheme than clients like Perl and PHP. You have to convert your MySQL passwords to the old version. This query worked for me:

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');