$(brew -prefix mariadb)/bin/mysqladmin -u root password newpass => Successfully started `mariadb` (label: ) If you run on Mojave, Catalina, Big Sur and now on macOS Monterey: brew install mariadb Pour yourself a coffee and get a backup solution in place! You've just reset your mysql root password. Now, lets put back the launch daemon so we have our MySQL at the ready again: launchctl load -w ~/Library/LaunchAgents/Ĭongratulations. If all went to plan it should say: Query OK, 1 row affected (0.02 sec)Įxit out of the MySQL prompt. mysql> update er set password=PASSWORD('new_password_here') WHERE user='root'

Log in and set the password mysql -u rootĪt the prompt, enter the following MySQL command to set a new password for the effected user. Once you have done this, you now should have a running, unprotected MySQL instance up. Note that if when you run echo $(brew -prefix mysql) and it does not respond as '/usr/local/opt/mysql' in bash, you will need to adjust the path accordingly. Now start mysql by hand skipping the grant tables and networking $(brew -prefix mysql)/bin/mysqld_safe -skip-grant-tables -skip-networking Stop the currently running MySQL instance launchctl unload -w ~/Library/LaunchAgents/ In his spare time, John-Anthony can be found watching any sport under the sun from football to darts, taking the term “Lego house” far too literally as he runs out of space to display any more plastic bricks, or chilling on the couch with his French Bulldog, Kermit.In case you have inadvertently set and forgot the root password, and you don't want to wipe all your databases and start over because you are lazy and forgot to have a back up solution in place, and you are using a fairly recent Homebrew install (Winter 2013), here are steps to reset your password for MySQL. John-Anthony also loves to tinker with other non-Apple technology and enjoys playing around with game emulation and Linux on his Steam Deck. He is also an avid film geek, having previously written film reviews and received the Edinburgh International Film Festival Student Critics award in 2019.

John-Anthony has previously worked in editorial for collectable TCG websites and graduated from The University of Strathclyde where he won the Scottish Student Journalism Award for Website of the Year as Editor-in-Chief of his university paper. Living in Scotland, where he worked for Apple as a technician focused on iOS and iPhone repairs at the Genius Bar, John-Anthony has used the Apple ecosystem for over a decade and prides himself in his ability to complete his Apple Watch activity rings. John-Anthony Disotto is the How To Editor of iMore, ensuring you can get the most from your Apple products and helping fix things when your technology isn’t behaving itself.

How to recover macbook password