How to Reset MySQL root password in Centos 7

MySQL Is an open-source Relational Database Management System (RDMS). It uses tables, triggers, variables, views, etc. MariaDB is a fork of MySQL. The database structures and indexes of MariaDB are same as the MySQL. This blog covers the steps to reset MySQL root password without any data loss.

Here in Skynats, we had done so many mysql root password reset without any data losses under our server management service.

Click here to get more info about: outsourced server support

Reset root password in Safe Mode

Check MySQL or MariaDB version

mysql --version
mysql Ver 15.1 Distrib 10.3.22-MariaDB, for Linux (x86_64) using readline 5.1

Stop MySQL/MariaDB service

systemctl stop mariadb

Then start MySQL/MariaDB in safe mode without loading the privileges

mysqld_safe --skip-grant-tables --skip-networking &

200306 10:56:59 mysqld_safe Logging to '/var/lib/mysql/mysqltest.err'.
200306 10:56:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

Then connect MySQL/MariaDB as root and run change password query/command

mysql -u root -p

MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
MariaDB [(none)]> exit

Next kill/stop the MySQL/MariaDB instance process id

For More Information:aws cloud management 

kill $(cat /var/lib/mysql/ )

Start MySQL/MariaDB in normal mode

systemctl start mariadb

Now, Login as mysql root user with new password

mysql -u root -p


You can able to login the MySQL/MariaDB using new root password.