- Go to: 'System Preferences' >> 'MySQL' and stop MySQL
OR,
- sudo /usr/local/mysql/support-files/mysql.server start
- sudo /usr/local/mysql/support-files/mysql.server stop
- sudo /usr/local/mysql/support-files/mysql.server status
-
Make sure you have Stopped MySQL first (above).
-
Run the server in safe mode with privilege bypass:
sudo mysqld_safe --skip-grant-tables
-
In a new window connect to the database, set a new password and flush the permissions & quit:
mysql -u root
-
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';
-
Now flush privileges:
FLUSH PRIVILEGES;
-
Restart MySQL server.
-
More info: http://stackoverflow.com/questions/6474775/setting-the-mysql-root-user-password-on-os-x
For the people who have errors like:
use
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpasswd';
instead.caching_sha2_password
doesn't seem like natively supported on some client applications. So in my casemysql_native_password
was needed.