How do I reset/recover my superuser password without the boot disk? Let you reset (but not recover) the old root password. Up on your Mac in addition to the.
I'm using SequelPro (http://www.sequelpro.com/)and I would like to know how to reset my root password.I'm trying to log in as
host: localhost
username: root
password: (BLANK)
But I keep getting this error:
Unable to connect to host because access was denied.
Double-check your username and password and ensure that access from your current location is permitted.
MySQL said: Access denied for user 'root'@'localhost' (using password: NO)
Any suggestions?!
Josh K
2 Answers
Depending on what you're using to run MySQL, you could take a look at the official instructions.
If you're using MAMP or something similar you need to find where mysqladmin is located.
If you are using another installation of mysql, you may be able to find out where it is located with:
Here is the procedure to reset password of root user.
1) Stop mysql (Kill mysql process or run following command)
2) Start it in safe mode
3) Open another terminal and run the following command (Keep last terminal open)
4) Run the following command with suitable new password on the mysql console
5) mysql > FLUSH PRIVILEGES;
6) Quit from both terminals and open new terminal and connect to mysql with root user and new password