< All Docs

How to reset the MySQL root password in CentOS 7

Create a Microhost account to try this guide with a $50 credit.

Table of Content

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!!

Previous How to reset forgotten root password in ubuntu 16/18
Next How To Reset Your MySQL or MariaDB Root Password on Ubuntu 18.04
Table of Contents