Reset lost MySQL user password - Linux

Resetting your lost password on MySQL is quite easy.

Step 1
Stop your running server and start MySQL on safe mode

# mysqld_safe --skip-grant-tables &

Step 2

Now login as root, you don't need a password here;

# mysql -u root


Step 3

Change the password using the UPDATE query


# UPDATE mysql.user SET Password=PASSWORD('type-new-password') WHERE User='root';

Step 4

Flush the privileges to get things done


# FLUSH PRIVILEGES;