A couple of times now, when starting from scratch on a new Mac, I have found myself forgetting how to update my local Root MySQL user password.
After all, it’s not like it’s something I need to do often.
Inevitably, I give it a Google and all of the first page results have some solutions, mostly using Command Line, but that may not be perfectly comfortable for some people.
For prosperity, the easiest command is such:
/Applications/MAMP/Library/bin/mysqladmin -u root -p password [NewPassword]
A perhaps easier method, depending on your experience and comfort-level using the command line, is to use Sequel Pro.
I’m against downloading software for arbitrary tasks, but if you’re managing MySQL databases on a Mac it’s my opinion that you really should have Sequel Pro installed anyway.
So, to update the MySQL Root (or any other user) password the easy way;
- Download/Open Sequel Pro
- Connect to your localhost using the following details, entering the current Root password (Note: The default MAMP Root password is ‘root’)
- Switch to the User Management tab using the ‘Users’ button in the top right of the window.
- Select ‘Root’ or ‘root’ from the left hand side list of MySQL users.
- Enter the new password in the ‘password’ field, and voila!