Posts Tagged ‘ mysql ’
Snow Leopard upgraded php to 5.3, this means that passwords have to be changed – usually via SET password FOR ‘user’@'host’ = PASSWORD( ‘password’ ). This is fine, and can be verified by SELECT LENGTH( password ), user FROM mysql.user. The result should be 41. I had inadvertently enabled old_password=1 in /etc/my.cnf, this caused both PASSWORD [ READ MORE ]