Reset Mysql Root password on Mac OSX25 Aug 2011
Had a strange issue where mysql started asking for a password for my local mysql after updating my mysql2 gem. So to fix this had to update my root password and here is how l did it
Stop MySQL service. You can do that using the preference pane if you have that installed or you can stop it using Terminal sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
- Skipping Access Tables. If you have installed MySQL5, fire up Terminal window and execute /usr/local/mysql/bin/mysqld_safe --skip-grant-tables For older versions of MySQL, execute the following command /usr/local/mysql/bin/safe_mysqld --skip-grant-tables
- Reset MySQL root password. Now when safe_mysqld running in one Terminal window, open up another Terminal window and execute /usr/local/mysql/bin/mysql mysql. This opening up the MySQL console and opening the mysql table so we can update MySQL root user. Write the reset query into the console as follows UPDATE user SET Password=PASSWORD(‘YOUR_PASSWORD’) WHERE Host=’localhost’ AND User=’root’;. Replace “YOUR_PASSWORD” with your desired password.
Once you’ve done that just exit the console “exit;” close the safe_mysqld execution and restart your MySQL server. You can do this using sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
Once you have done that you can access mysql again with no issues