Reset MySQL root password [Ubuntu 12.04]

If you want reset your MySQL root password follow the below simple steps.

Stop MySQL server

# service mysql stop

Restart MySQL with option --skip-grant-tables, i.e permissions are not loaded and so disable networking

# /usr/sbin/mysql --skip-grant-tables --skip-networking

Now login to the mysql shell as root user, and no password

# mysql -u root

The user passwords are in the table mysql.user in password column update them

mysql>use mysql;
mysql>update user set password=password('inctfmysql') where user='root';

Now give the below command to commit the changes

mysql>flush privileges;

Restart the MySQL server

# service mysql restart