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

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

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.