Have you forgotten your MySQL root password? I must admit I've been guilty of this a few times. Also helpful if you are working on a project where the previous developer or server admin has vanished. This article tells you how to reset your password.
You will need root access to the Linux box running the database.
Here are the steps to recover your MySQL password.
Step 1
Log in as root on the Linux server.
sudo su
Step 2
Create a file named “mysql-init†in your /root directory.
touch /root/mysql-init
Step 3
Place the following in your mysql-init file, be sure to change "myNEWpassword" to your new password:
UPDATE mysql.user SET Password=PASSWORD('myNEWpassword') WHERE User='root';
FLUSH PRIVILEGES;
Note: ensure UPDATE and FLUSH are on their own lines.
Step 4
Turn off your mysql service.
killall mysqld
Step 5
Run your mysql-init
mysqld_safe --user=mysql --init-file=/root/mysql-init &
Note: Make sure the user is set to your mysql user.
Step 6
After the server has started successfully, delete your mysql-init for security.
rm /root/mysql-init
Comments