Forgotten MariaDB root password

Problem

User forgott 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