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

Last active September 27, 2025 02:50

Star (195) You must be signed in to star a gist
Fork (59) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/zubaer-ahammed/c81c9a0e37adc1cb9a6cdc61c4190f52.js"></script>
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:

MySQL:

Go to: 'System Preferences' >> '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

UPDATE mysql.user SET authentication_string=PASSWORD("rootpass") WHERE User='root';

Process to Reset MySQL Root Pass in Mac:

Stop MySQL
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';
FLUSH PRIVILEGES;
Restart MySQL server.
More info: http://stackoverflow.com/questions/6474775/setting-the-mysql-root-user-password-on-os-x

shalithadev commented Sep 6, 2022 •

edited

Loading

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 commented Sep 24, 2022 •

edited

Loading

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 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 commented Oct 10, 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';

Worked for me. Thanks!

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 commented Nov 22, 2022

this works for me. thank you!

santex commented Dec 29, 2022

mysql -u root

cheers

wiyantotan commented Jan 25, 2023

For mysql 8 in MacOS

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

Start new terminal

cd /usr/local/mysql/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

monkeyminds-io commented Feb 2, 2023

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 commented Feb 16, 2023

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 commented Mar 15, 2023

For mysql 8 in MacOS

stop all mysql server service

cd /usr/local/mysql/bin

sudo ./mysqld_safe --skip-grant-tables

this will start mysql server in this terminal

Start new terminal

cd /usr/local/mysql/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

Thanks! works for mysql 8.0.28

httol commented May 16, 2023

brew services restart mysql

Yes

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 commented Jun 4, 2023

mysql -u root

oh thanks i can go to sleep <3 :D

s-gorton commented Oct 4, 2023

For mysql 8 in MacOS

stop all mysql server service

cd /usr/local/mysql/bin

sudo ./mysqld_safe --skip-grant-tables

this will start mysql server in this terminal

Start new terminal

cd /usr/local/mysql/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

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 commented Apr 4, 2024

For mysql 8 in MacOS

stop all mysql server service

cd /usr/local/mysql/bin

sudo ./mysqld_safe --skip-grant-tables

this will start mysql server in this terminal

Start new terminal

cd /usr/local/mysql/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

Thanks! works for mysql 8.0.28

This worked for me, thank you!

BeKind-Rewind commented May 9, 2024

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 commented Jun 17, 2024

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 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 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 commented Jul 19, 2024

mysql -u root

"$ brew install mysql"
install and try it

Zia9335 commented Sep 18, 2024

Thanks. it worked

IfeBusola263 commented Oct 10, 2024 •

edited

Loading

For mysql 8 in MacOS

stop all mysql server service

cd /usr/local/mysql/bin

sudo ./mysqld_safe --skip-grant-tables

this will start mysql server in this terminal

Start new terminal

cd /usr/local/mysql/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

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 commented Oct 10, 2024

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 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 commented Feb 5, 2025 via email

You are welcome. Get Outlook for iOS<https://aka.ms/o0ukef>

…

________________________________ From: Edgardo Guzman Jr ***@***.***> Sent: Tuesday, February 4, 2025 8:47:13 PM To: eegyolk ***@***.***> Cc: Manual ***@***.***> Subject: Re: zubaer-ahammed/Reset MySQL Root Password in Mac OS.md @eegyolk commented on this gist.

________________________________ 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! — Reply to this email directly, view it on GitHub<https://gist.github.com/zubaer-ahammed/c81c9a0e37adc1cb9a6cdc61c4190f52#gistcomment-5423958> or unsubscribe<https://github.com/notifications/unsubscribe-auth/AWYG2HXIFW37A3WHGS4I7PL2OF3TFBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVA3TIMZZGM3DQM5HORZGSZ3HMVZKMY3SMVQXIZI>. You are receiving this email because you are subscribed to this thread. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

gabriel-mopereira commented Feb 14, 2025

For mysql 8 in MacOS

stop all mysql server service

cd /usr/local/mysql/bin

sudo ./mysqld_safe --skip-grant-tables

this will start mysql server in this terminal

Start new terminal

cd /usr/local/mysql/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

This worked for me, thanks.

anthonysim commented Apr 18, 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!

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

Dheerendra69 commented Jun 27, 2025

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 commented Aug 11, 2025

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)

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

Reset mysql root password in Mac OS:

MySQL:

Process to Reset MySQL Root Pass in Mac:

shalithadev commented Sep 6, 2022 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

daniellemaxwell commented Sep 24, 2022 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

mahshad commented Oct 3, 2022

Uh oh!

dyfloveslife commented Oct 10, 2022

Uh oh!

ohadnav commented Nov 14, 2022

Uh oh!

kerenren commented Nov 22, 2022

Uh oh!

santex commented Dec 29, 2022

Uh oh!

wiyantotan commented Jan 25, 2023

Uh oh!

monkeyminds-io commented Feb 2, 2023

Uh oh!

basiltime commented Feb 16, 2023

Uh oh!

DouggyC commented Mar 15, 2023

Uh oh!

httol commented May 16, 2023

Uh oh!

quicksilverr commented Jun 3, 2023 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

v-zhg3nti commented Jun 4, 2023

Uh oh!

s-gorton commented Oct 4, 2023

Uh oh!

mbm-source commented Apr 4, 2024

Uh oh!

BeKind-Rewind commented May 9, 2024

Uh oh!

swayamterode commented Jun 17, 2024

Uh oh!

Victorcorcos commented Jul 4, 2024 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

ShreySharma07 commented Jul 10, 2024

Uh oh!

RavvyS commented Jul 19, 2024

Uh oh!

Zia9335 commented Sep 18, 2024

Uh oh!

IfeBusola263 commented Oct 10, 2024 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

IfeBusola263 commented Oct 10, 2024

Uh oh!

eegyolk commented Feb 5, 2025

Uh oh!

RolandaAnwar commented Feb 5, 2025 via email

Uh oh!

gabriel-mopereira commented Feb 14, 2025

Uh oh!

anthonysim commented Apr 18, 2025

Uh oh!

Dheerendra69 commented Jun 27, 2025

Uh oh!

mqliutie commented Aug 11, 2025

Uh oh!

shalithadev commented Sep 6, 2022 •

edited

Loading

daniellemaxwell commented Sep 24, 2022 •

edited

Loading

quicksilverr commented Jun 3, 2023 •

edited

Loading

Victorcorcos commented Jul 4, 2024 •

edited

Loading

IfeBusola263 commented Oct 10, 2024 •

edited

Loading