Reset Mysql root password in Mac OS

First Stop MySQL:

1. Go to: 'System Preferences' >> 'MySQL' and stop MySQL

OR,

1. sudo /usr/local/mysql/support-files/mysql.server start
2. sudo /usr/local/mysql/support-files/mysql.server stop
3. sudo /usr/local/mysql/support-files/mysql.server status

Process to Reset MySQL Root Pass in Mac:

1. Make sure you have Stopped MySQL first (above).
2. Run the server in safe mode with privilege bypass: sudo mysqld_safe --skip-grant-tables
3. In a new window connect to the database, set a new password and flush the permissions & quit: mysql -u root
4. For MySQL older than MySQL 5.7 use:

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

   For MySQL 5.7+ use:

   UPDATE mysql.user SET authentication_string=PASSWORD("rootpass") WHERE User='root';

   ( If the above don't work try sql query) Eg :- mysql> UPDATE mysql.user SET authentication_string="rootpass" WHERE User='root'; 
5. Now flush privileges:    mysql> FLUSH PRIVILEGES;
   

   FLUSH PRIVILEGES;

6. Restart MySQL server. mysql> quit
7. In Terminal use sudo /usr/local/mysql/support-files/mysql.server restart
8. More info: http://stackoverflow.com/questions/6474775/setting-the-mysql-root-user-password-on-os-x

Regards,

Bala K