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)]> FLUSH PRIVILEGES;
MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit
Next kill/stop the MySQL/MariaDB instance process id
For More Information:aws cloud managementÂ
kill $(cat /var/lib/mysql/mysqltest.pid )
Start MySQL/MariaDB in normal mode
systemctl start mariadb
Now, Login as mysql root user with new password
mysql -u root -p
Password:
You can able to login the MySQL/MariaDB using new root password.