KB10002 Forgotten MariaDB root password

KB ID: 10002

Product: vProtect

Version: 3.8.0 +

Published: 2020-02-04

Last modified: 2020-02-04

Problem

User forgot MariaDB root password set in server initialization job, and can't run vProtect database backup.

Reset root password in MariaDB.

Before that stop vprotect-server

systemctl stop vprotect-server

[root@vProtect01 ~]# systemctl stop vprotect-server

Stop MariaDB service.

systemctl stop mariadb

[root@vProtect01 ~]# systemctl stop mariadb

Start MariaDB service in unrestricted access.

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

[root@vProtect01 ~]# mysqld_safe --skip-grant-tables --skip-networking &

Now you can login to MariaDB, and reset password.

mysql -u root

[root@vProtect01 ~]# mysql -u root

use mysql;

update user set password=PASSWORD("new-password-to-MariaDB") where User='root';

flush privileges;

exit

Restart MariaDB, and run vprotect-server

systemctl

[root@vProtect01 ~]# systemctl restart mariadb

[root@vProtect01 ~]# systemctl start vprotect-server

Now you can use "new-password-to-MariaDB" to login as root.

mysql -u root -pnew-password-to-MariaDB

[root@vProtect01 ~]# mysql -u root -pnew-password-to-MariaDB