Reset MySQL Root Password in Mac OS

Reset MySQL Root Password in Mac OS.md

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';

5. Now flush privileges:

   FLUSH PRIVILEGES;

6. Restart MySQL server.

7. More info: http://stackoverflow.com/questions/6474775/setting-the-mysql-root-user-password-on-os-x

When I typed this: mysql -u root, I got this error!

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
had the same issue too, it was because you had not started the mysql service again.