How to Reset MySQL Root Password?

If you have lost your MySQL root password then don’t worry, Here are few easy steps which will help you to recover MySql root password.

1. Stop all the MySQL Processes

On Ubuntu & Debian distributions:

On CentOS, Fedora & RHEL distributions:

2. Start MySQL Server in Safe Mode

3. Connect to the MySQL Server

Now safe mode has started up, Now log into MySQL using your standard root password.

4. Change New MySQL Root Password

5. Stop MySQL Server and Start MySQL

Ubuntu and Debian:

CentOS, Fedora and RHEL:

Now MySql root password is reset. Now you can test your new MySQL root password.

Leave a Reply

Your email address will not be published. Required fields are marked *