How to reset the MySQL root password

Spread the love
How to reset the mysql root password on Linux.

Stop the mysql server:-
/etc/init.d/mysql stop

Start the mysql server manually without permission tables which allows us to login as root user without password:
 mysqld_safe –skip-grant-tables &

Login into mysql as root user without a password and switch to the “mysql” database:
mysql -u root mysql
Then execute this SQL query to set a new password for the mysql root user:
update user set Password=PASSWORD(‘mynewpassword’) WHERE User=’root’;
(Replace “mynewpassword” with the new root password in the above command).

Then logout from the mysql prompt by typing:

Start the mysql server again:-
/etc/init.d/mysql start

See also  Audit Your Linux Security With Lynis

Leave a Comment