Post-Installation on a Mac OSX Snow Leopard

anjanesh · #1 (**permalink**) 10-15-11, 05:44

I installed MySQL on a Mac OSX Snow Leopard and got the mysql service started but I couldn't login as root to reset the password.

1. ./mysql - logs in with no username and no password but show databases doesnt show a mysql database.

2. Couldn't login as root either.

Code:

$ ./mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO

3. Neither did mysqladmin work

Code:

./mysqladmin -u root password "password"
./mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Is there any other way ?

it-iss.com · #2 (**permalink**) 10-17-11, 02:51

Hi,

I did put together a video tutorial on how to reset the root password if it became lost. This might be of interest to you: MySQL - changing lost root password - YouTube

anjanesh · #3 (**permalink**) 11-03-11, 08:23

Thanks ! This worked. Yay ! There are some differences though. On my Mac 10.6.6, process usernames dont show up on ps -ef. It shows the userid instead. I had to just figure out the userid (0 being root and the other one being mysql).

Internet Services

Web Development

Digital Marketing

Consumer Tech