Re: MySQL server won't start (Apple OS)

[Mike Levin]

ok. So I killed the instance I had (all 3 PIDs), and did this:

sudo ./mysqld_safe --skip-grant-tables ;

then in another window, I was able to get in without a password, and change the password:

sudo /usr/local/mysql/bin/mysql -u root
mysql> UPDATE mysql.user SET Password=PASSWORD('xxxxxx') WHERE User='root';
mysql> FLUSH PRIVILEGES;

and then I restarted:

sudo ../support-files/mysql.server start

but oddly, with this password, I can't get back in! None of my clients work, even though I know perfectly well what I set the password to - they all say

mlevin% sudo /usr/local/mysql/bin/mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
mlevin% sudo /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

what is going on here - why won't it let me use the password I just set??