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

MacOSX MySql root Password Reset master solution Step by step guide- $ brew services stop mysql $ pkill mysqld $ rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!! $ brew postinstall mysql $ brew services restart mysql $ mysql -u root

Thanks this worked for me

hey , I have a problem
when I enter ' sudo mysqld_safe --skip-grant-tables ' and the doing my password the answer that I get is 'sudo: mysqld_safe: command not found' , what can I do ? I can't reset my password for mysql ...
need help

I have the same error. :(

For Mac users, the best option is to uninstall the current version and re install. Then you would have option to enter a new password. It worked for me.

Update: On 8.0.15 (maybe already before that version) the PASSWORD() function does not work You have to do:
Make sure you have Stopped MySQL first (above).
Run the server in safe mode with privilege bypass: sudo mysqld_safe --skip-grant-tables
mysql -u root
UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;
Then
mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

Thanks!

Update: On 8.0.15 (maybe already before that version) the PASSWORD() function does not work You have to do:

Make sure you have Stopped MySQL first (above).
Run the server in safe mode with privilege bypass: sudo mysqld_safe --skip-grant-tables
mysql -u root
UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;
Then
mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

I am using MYSQL 8.0.28 on mac m1 and this worked for me, but make sure you close down MYSQL safe start before restarting it after this process and your new password set here will work

Amazing!

Update: On 8.0.15 (maybe already before that version) the PASSWORD() function does not work You have to do:

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
   mysql -u root
UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;
   Then
   mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

Worked.

Update: On 8.0.15 (maybe already before that version) the PASSWORD() function does not work You have to do:

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
   mysql -u root
UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;
   Then
   mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

For the people who have errors like:

ER_NOT_SUPPORTED_AUTH_MODE
'cryptography' package is required for sha256_password or caching_sha2_password auth methods

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 case mysql_native_password was needed.

Update: On 8.0.15 (maybe already before that version) the PASSWORD() function does not work You have to do:

Make sure you have Stopped MySQL first (above).
Run the server in safe mode with privilege bypass: sudo mysqld_safe --skip-grant-tables
mysql -u root
UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;
Then
mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

I am using MYSQL 8.0.28 on mac m1 and this worked for me, but make sure you close down MYSQL safe start before restarting it after this process and your new password set here will work

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.

> **MacOSX MySql root Password Reset master solution**
> **Step by step guide-**
> $ brew services stop mysql
> $ pkill mysqld
> $ rm -rf /usr/local/var/mysql/ **# NOTE: this will delete your existing database!!!**
> $ brew postinstall mysql
> $ brew services restart mysql
> $ mysql -u root

This has worked for me

Thanks 👍

WORKED FOR ME <3

the bad news : no solution from above worked for me the good news : just i initialize database from with new password, and it's working now

worked for me. 👍🏾

Update: On 8.0.15 (maybe already before that version) the PASSWORD() function does not work You have to do:

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
   mysql -u root
UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;
   Then
   mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

This worked for me. Just dont forget to exit server, stop server and then restart.

Thanks Paul, this worked!

@sagrawal31 Thank you very much. It's work for me too.

https://gist.github.com/zubaer-ahammed/c81c9a0e37adc1cb9a6cdc61c4190f52?permalink_comment_id=3656328#gistcomment-3656328

I use homebrew but this only succeeded in returning me back to the original password...

Update: On 8.0.15 (maybe already before that version) the PASSWORD() function does not work You have to do:

Make sure you have Stopped MySQL first (above).
Run the server in safe mode with privilege bypass: sudo mysqld_safe --skip-grant-tables
mysql -u root
UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;
Then
mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

I am using MYSQL 8.0.28 on mac m1 and this worked for me, but make sure you close down MYSQL safe start before restarting it after this process and your new password set here will work

This really works!!!

Here's what worked for me:
Make sure you have stopped MySQL (as mentioned above)
Run the server in safe mode with privilege bypass: sudo mysqld_safe --skip-grant-tables
In a new terminal: mysql -u root
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
exit
Shut down the server in safe mode
Then
mysql -u root
If mysql -u root doesn't work try: mysql -u root -p

Thank you all for your help and input ... I'm using M1 chip silicon setup, and the following worked for me;

brew services stop mysql
pkill mysqld
rm -rf /usr/local/var/mysql/
brew postinstall mysql
brew services restart mysql
mysql -u root
UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;
mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'secret';

Worked for me. Thanks!

Update: On 8.0.15 (maybe already before that version) the PASSWORD() function does not work You have to do:

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
   mysql -u root
UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;
   Then
   mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';

Worked for me. Thanks!

> **MacOSX MySql root Password Reset master solution**
> **Step by step guide-**
> $ brew services stop mysql
> $ pkill mysqld
> $ rm -rf /usr/local/var/mysql/ **# NOTE: this will delete your existing database!!!**
> $ brew postinstall mysql
> $ brew services restart mysql
> $ mysql -u root

This has worked for me

Thanks 👍

WORKED FOR ME <3

running rm -rf /usr/local/var/mysql/ ** deleted all my files 😱

this works for me. thank you!

mysql -u root

cheers

For mysql 8 in MacOS

1. stop all mysql server service
2. cd /usr/local/mysql/bin
3. sudo ./mysqld_safe --skip-grant-tables
4. this will start mysql server in this terminal

Start new terminal

1. cd /usr/local/mysql/bin
2. sudo ./mysql -u root
3. FLUSH PRIVILEGES;
4. UPDATE mysql.user SET authentication_string=null WHERE User='root';
5. FLUSH PRIVILEGES;
6. exit;
7. sudo ./mysql -u root
8. ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';
9. FLUSH PRIVILEGES;
10. exit;
11. sudo ./mysqladmin -u root shutdown -p (this will shutdown mysql server that started at the other terminal)
12. start mysql with the normal way

MacOSX MySql root Password Reset master solution
Step by step guide-
$ brew services stop mysql
$ pkill mysqld
$ rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!!
$ brew postinstall mysql
$ brew services restart mysql
$ mysql -u root

Thanks a lot!! This really works!!

Initializing the database from Mac's System Settings worked 👏 I tried a few of the other methods and none worked for me.

System Settings -> MySQL -> Initialize Database.

It will ask for a password, that's where you choose a new one.

For mysql 8 in MacOS

1. stop all mysql server service
2. cd /usr/local/mysql/bin
3. sudo ./mysqld_safe --skip-grant-tables
4. this will start mysql server in this terminal

Start new terminal

1. cd /usr/local/mysql/bin
2. sudo ./mysql -u root
3. FLUSH PRIVILEGES;
4. UPDATE mysql.user SET authentication_string=null WHERE User='root';
5. FLUSH PRIVILEGES;
6. exit;
7. sudo ./mysql -u root
8. ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';
9. FLUSH PRIVILEGES;
10. exit;
11. sudo ./mysqladmin -u root shutdown -p (this will shutdown mysql server that started at the other terminal)
12. start mysql with the normal way

Thanks! works for mysql 8.0.28

brew services restart mysql

Yes

new terminal: mysql -u root
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
exit
Shut down the server in safe mode
Then
mysql -u root
If mysql -u root doesn't work try: mysql -u root -p

while doing this

I'm getting this error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

mysql -u root

oh thanks i can go to sleep <3 :D

For mysql 8 in MacOS

1. stop all mysql server service
2. cd /usr/local/mysql/bin
3. sudo ./mysqld_safe --skip-grant-tables
4. this will start mysql server in this terminal

Start new terminal

1. cd /usr/local/mysql/bin
2. sudo ./mysql -u root
3. FLUSH PRIVILEGES;
4. UPDATE mysql.user SET authentication_string=null WHERE User='root';
5. FLUSH PRIVILEGES;
6. exit;
7. sudo ./mysql -u root
8. ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';
9. FLUSH PRIVILEGES;
10. exit;
11. sudo ./mysqladmin -u root shutdown -p (this will shutdown mysql server that started at the other terminal)
12. start mysql with the normal way

When i get to 'flush privileges' i get a key icon - i attempted the flush privileges three times and it says 'incorrect passwords attempts'...? what does this mean?

For mysql 8 in MacOS

1. stop all mysql server service
2. cd /usr/local/mysql/bin
3. sudo ./mysqld_safe --skip-grant-tables
4. this will start mysql server in this terminal

Start new terminal

1. cd /usr/local/mysql/bin
2. sudo ./mysql -u root
3. FLUSH PRIVILEGES;
4. UPDATE mysql.user SET authentication_string=null WHERE User='root';
5. FLUSH PRIVILEGES;
6. exit;
7. sudo ./mysql -u root
8. ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';
9. FLUSH PRIVILEGES;
10. exit;
11. sudo ./mysqladmin -u root shutdown -p (this will shutdown mysql server that started at the other terminal)
12. start mysql with the normal way

Thanks! works for mysql 8.0.28

This worked for me, thank you!