MySQL password issues (mac OS X Lion) [closed]

Question

I am trying to set the root password for MySQL in the terminal in Mac OS X Lion, and I am having issues. Every time I use the line:

/usr/local/mysql/bin/mysqladmin -u root password ******  (where ****** is the password I want to set) 

I receive the error:

/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' 

I have not set a password previously, so I do not know why I am receiving this error.

Answer 1

Here is the procedure to reset password of root user.

1) Stop mysql (Kill mysql process or run following command)

sudo /usr/local/mysql/support-files/mysql.server stop 

2) Start it in safe mode

sudo mysqld_safe --skip-grant-tables 

3) Open another terminal and run the following command (Keep last terminal open)

mysql -u root 

4) Run the following command with suitable new password on the mysql console

For MySQL 5.7+:

mysql > UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE User='root'; 

For earlier versions:

mysql > UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; 

5) mysql > FLUSH PRIVILEGES;

6) Quit from both terminals and open new terminal and connect to mysql with root user and new password

mysql -uroot -p