MySQL - reset a lost MySQL root password
The MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken including creating new users, new databases, setting access rules and so on.
The first thing to do is stop MySQL.
sudo /etc/init.d/mysql stop
Now start mysql in safe mode.
Next we need to start MySQL in safe mode - that is to say, we will start MySQL but skip the user privileges table.
sudo mysqld_safe –skip-grant-tables &
*ampersand (&) at the end of the command is required.
Login
mysql -u root
Next, instruct MySQL which database to use:
use mysql;
Reset password
Enter the new password for the root user as follows:
update user set password=PASSWORD(”mynewpassword”) where User=’root’;
and finally, flush the privileges and then stop and start mysql.
flush privileges;
Leave a Reply
You must be logged in to post a comment.
