PHP 5.3 on Snow Leopard with mysqlnd
Filed Under (mysql, php) by admin on 26-11-2009
Tagged Under : mysql, mysqlnd, php, snow leopard
On snow leopard the bundled version of PHP installed is 5.3 And it’s new PHP mysql driver is mysqlnd not the old one (ext/mysql)
This might cause the following error:
mysqlnd cannot connect to MySQL 4.1+ using old authentication
Solution:
type in mysql
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Findings:
Because mysqlnd has a bigger password hash it will not be compatible anymore with the password written beforehand.
