Skip to content

Instantly share code, notes, and snippets.

@zubaer-ahammed
Last active October 14, 2024 21:16
Show Gist options
  • Save zubaer-ahammed/c81c9a0e37adc1cb9a6cdc61c4190f52 to your computer and use it in GitHub Desktop.
Save zubaer-ahammed/c81c9a0e37adc1cb9a6cdc61c4190f52 to your computer and use it in GitHub Desktop.
Reset MySQL Root Password in Mac OS

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

@hassan-sempro
Copy link

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.

@namxhung
Copy link

namxhung commented Jun 10, 2022

> **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

@josefophe
Copy link

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. 👍🏾

@JasmineDaniels
Copy link

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!

@vovs03
Copy link

vovs03 commented Aug 9, 2022

@BeKind-Rewind
Copy link

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

@hashaaan
Copy link

hashaaan commented Sep 6, 2022

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!!!

@daniellemaxwell
Copy link

daniellemaxwell commented Sep 24, 2022

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

@mahshad
Copy link

mahshad commented Oct 3, 2022

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!

@dyfloveslife
Copy link

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!

@ohadnav
Copy link

ohadnav commented Nov 14, 2022

> **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 😱

@kerenren
Copy link

this works for me. thank you!

@santex
Copy link

santex commented Dec 29, 2022

mysql -u root

cheers

@wiyantotan
Copy link

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

@monkeyminds-io
Copy link

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!!

@basiltime
Copy link

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.

@DouggyC
Copy link

DouggyC commented Mar 15, 2023

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

@httol
Copy link

httol commented May 16, 2023

brew services restart mysql

Yes

@quicksilverr
Copy link

quicksilverr commented Jun 3, 2023

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)

@v-zhg3nti
Copy link

mysql -u root

oh thanks i can go to sleep <3 :D

@s-gorton
Copy link

s-gorton commented Oct 4, 2023

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?

@Bouff6
Copy link

Bouff6 commented Apr 4, 2024

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!

@BeKind-Rewind
Copy link

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

Worked for me too! Thank you!

@swayamterode
Copy link

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'

@Victorcorcos
Copy link

Victorcorcos commented Jul 4, 2024

I’m having the same issue and the solution proposed didn’t work.

I’ve tried to change the password for the root user by executing sudo mysqld_safe --skip-grant-tables , then mysql -root, then the commands to reset the password, but it says that a mysqld process already exists, which blocks the execution of further commands.

$ sudo mysqld_safe --skip-grant-tables

2024-07-04T17:57:49.6NZ mysqld_safe Logging to '/opt/homebrew/var/mysql/Victors-MacBook-Pro.local.err'.
2024-07-04T17:57:49.6NZ mysqld_safe A mysqld process already exists

↳ This error is happening even after I kill all of the mysqld/mysql processes with sudo kill -9 or sudo pkill -9 mysqld or sudo killall -9 mysqld or sudo killall -9 mysqld_safe or listing all the processes with ps aux | grep mysql and killing each one of them manually via sudo kill -9 <process_id>.

I also tried to uninstall mysql, but when I run the the mysql_secure_installation command and try to setup a password, the following access denied error happens:

$ mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root: 
Error: Access denied for user 'root'@'localhost' (using password: YES)

So, in the end, I can’t use MySQL at all on my machine due to this login issue. Could someone help me? Thank you!

@Bidyut7
Copy link

Bidyut7 commented Jul 10, 2024

sudo mysqld_safe --skip-grant-tables

after safe mode it is still showing the same error...what to do now??

@RavvyS
Copy link

RavvyS commented Jul 19, 2024

mysql -u root

"$ brew install mysql"
install and try it

@Zia9335
Copy link

Zia9335 commented Sep 18, 2024

Thanks. it worked

@IfeBusola263
Copy link

IfeBusola263 commented Oct 10, 2024

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

Thank you so much! This worked for me.

To add, if your sql was installed with brew, you may not have the executables in /usr/local/mysql/bin, so check /opt/homebrew/Cellar/mysql/8.3.0_1/bin and just follow the exact same steps.

like so, i have copied from the solution of @DouggyC , and just added the file path

For mysql 8.3.0 in MacOS

stop all mysql server service
cd /opt/homebrew/Cellar/mysql/8.3.0_1/bin
sudo ./mysqld_safe --skip-grant-tables
this will start mysql server in this terminal

Start new terminal

cd /opt/homebrew/Cellar/mysql/8.3.0_1/bin
sudo ./mysql -u root
FLUSH PRIVILEGES;
UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;
sudo ./mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd';
FLUSH PRIVILEGES;
exit;
sudo ./mysqladmin -u root shutdown -p (this will shutdown mysql server that started at the other terminal)
start mysql with the normal way
`

@IfeBusola263
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment