Skip to content

Instantly share code, notes, and snippets.

@zubaer-ahammed

zubaer-ahammed/Reset MySQL Root Password in Mac OS.md

Last active September 27, 2025 02:50
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.
Download ZIP
Reset MySQL Root Password in Mac OS
Raw
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

@quicksilverr
Copy link

quicksilverr commented Jun 3, 2023 •
edited
Loading

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?

@mbm-source
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

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 •
edited
Loading

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!

@ShreySharma07
Copy link

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 •
edited
Loading

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.

@eegyolk
Copy link

eegyolk commented Feb 5, 2025

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

This works for me. Thanks a lot!

@RolandaAnwar
Copy link

RolandaAnwar commented Feb 5, 2025 via email

@gabriel-mopereira
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

This worked for me, thanks.

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

This works for me. Thanks a lot!

I asked ChatGPT and nothing worked so I ended here and this worked! Thanks ya'll!

@Dheerendra69
Copy link

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!

Worked for me as well. Thanks!

@mqliutie
Copy link

After updating my password, the terminal show me error as below :
mysql: [Warning] Using a password on the command line interface can be insecure.
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

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