I have a mySQL / PHP setup that I've used on several systems. I just recently upgraded my system to Max OSX 10.6, and now it cannot connect. I get the error:
mysqlnd cannot connect to MySQL 4.1+ using old authentication
I've done the obvious google searches, but most of them seem to be all about how to get mysql to use the old password style, which seems like it will no longer work. In any case, I want to find a better solution that allows me to use the newer password style.
I create my password with:
mysql> UPDATE mysql.user SET Password=PASSWORD('mypassword') WHERE User='root';
(or OLD_PASSWORD, it doesn't seem to matter)
and I log into the database with:
where $username is root and $password="mypassword"
What is the CORRECT solution to this problem, as forcing it keep using the old password technology is clearly NOT the right solution...
ps if this belongs on stackoverflow or superuser, let me know...