How to Reset MariaDB Root Password on CentOS 7. Today i logged in into my testing server (server for testing and learning, not my production server) because i want to test some server configuration. And because i am long time not login to this server, i am forgot my MariaDB password *lol. So, today i will show you how to reset MariaDB or MySQL database password.
If you have same problem as me (forgot mysql password), don’t worry, you can reset it if you have root or sudo access to your server.
First, you need to stop MariaDB process with this command
sudo service mariadb stop
Then run the service with safe mode command
sudo mysqld_safe --skip-grant-tables &
Now, you can login to your MariaDB without password
mysql -u root -p
Then, you can reset the password MariaDB password with this following command
use mysql; update user SET PASSWORD=PASSWORD("password") WHERE USER='root'; flush privileges; exit
Obviously you need to replace “password” with strong password.
After exit from MariaDB client, you need to kill all database process.
pkill -f 'mysql'
Then, restart MariaDB
sudo service mariadb restart
Now, you can login with your new password
[[email protected] ~]# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 5.5.60-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
That’s it. Hope this solution will help to fix your problem.