How to reset the MySQL root password in CentOS 7

MySQL is an open-source relational database management system . Its name consists a combination of ‘My’ and ‘SQL’ as the name for the Structured Query Language of the co-founder Michael Widenius’s daughter.

Step 1: Login into the server using root credentials on putty.

Step 2. Stop the mysql service using the below command.

# service mysqld stop 

Step 3. Set the mySQL environment option by using the below command.

# systemctl set-environment MYSQLD_OPTS="--skip-grant-tables 

Step 4. Start the mysql service .

# systemctl start mysqld 

Step 5. Login to mysql using root user

# mysql -u root 

Step 6. Update the root user password with these mysql commands

 mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword') -> WHERE User = 'root' AND Host = 'localhost' 

 mysql> FLUSH PRIVILEGES; 

 mysql> quit 

Step 7. Stop mysqld service.

# systemctl stop mysqld 

Step 8. Unset the mysql environment option so it starts normally next time.

# systemctl unset-environment MYSQLD_OPTS 

Step 9. Start mysql normally.

# systemctl start mysqld 

Step 10. Now, login to mysql with the new password as shown in the below screenshot.

Thank you!!