This blog will guide you on how to reset myql root user password.
Quick and easy four steps to Set / change / reset the MySQL root password on Ubuntu Linux.
Step 1: Presumming mysql process is running now stop the mysql server
by executing following command.
sudo /etc/init.d/mysql stop
Step 2: Now start the mysqld with skip grant tables this will allow us to login mysql without password.
sudo mysqld --skip-grant-tables &
Step 3: Now login to MySQL as root user, execute following command on terminal. It will show you the mysql prompt.
mysql -u root mysql
Step 4: Reset root user password.
UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;