KB10005 Forgotten MariaDB root password (MariaDB >=10.4)

KB ID: 10005

Product: vProtect

Version: 3.9.2 +

Published: 2021-02-23

Last modified: 2021-02-23

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 &

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

Now you can login to MariaDB, and reset password.

mysql -u root

[root@vProtect01 ~]# mysql -u root

flush privileges;

set password for root@localhost = password('new-password');

shutdown;

quit;

Run MariaDB, and run vprotect-server

systemctl

[root@vProtect01 ~]# systemctl start mariadb

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

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

mysql -u root -p new-password

[root@vProtect01 ~]# mysql -u root -p new-password