Mac MySQL Access denied for user problem solving method

Excerpt from StackOverflow answer

Here are 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

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

Mac MySQL Access denied for user problem solving method