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.
Log in as root on the Linux server.
Create a file named mysql-init in your /root directory.
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.
Turn off your mysql service.
sudo service mysql stop
Run your mysql-init
mysqld_safe --user=mysql --init-file=/root/mysql-init &
Note: Make sure the user is set to your mysql user.
sudo service mysql restart
After the server has started successfully, delete your mysql-init for security.