How to Reset MySQL Root Password in Linux

Resetting MySQL Root Password in Linux

Forgetting the root password of your MySQL database in Linux can be a common issue. However, you can easily reset it by following these steps:

1. Stop the MySQL service using: sudo systemctl stop mysql
2. Start MySQL in safe mode: sudo mysqld_safe --skip-grant-tables &
3. Connect to MySQL as root: mysql -u root
4. Set a new password: USE mysql; UPDATE user SET authentication_string=PASSWORD('new_password') WHERE User='root'; FLUSH PRIVILEGES; QUIT;
5. Stop MySQL safe mode: sudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown
6. Start the MySQL service normally: sudo systemctl start mysql
7. Now, you can login to MySQL using the new password.