- 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
I apologize for such a basic question - I have no idea how to do any of this. I am brand new to MySQL and tech in general. Where am I supposed to enter this? In Terminal? I have an M1 as well and the same version of MySQL Workbench. This has been frustrating me for a few days now.