How to Reset the MySQL root password on Ubuntu Linux

Enter the following lines in your terminal. Stop the MySQL Server.


sudo /etc/init.d/mysql stop

sudo /etc/init.d/mysql stop

Start the mysqld configuration.


sudo mysqld --skip-grant-tables &amp;

sudo mysqld --skip-grant-tables &


mysql -u root mysql

mysql -u root mysql

Replace YOURNEWPASSWORD with your new password!


UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root';

FLUSH PRIVILEGES;

exit;

UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root';

FLUSH PRIVILEGES;

exit;