📚
Documentation
Installation guides, configuration steps, and product documentation.
KB10002 Reset MariaDB root password for vProtect database backups
Publish date: Feb 4, 2020
Modification date: Jul 16, 2026
Affected Version: 3.8.0 +
Description
The issue occurs when the MariaDB root password, which is set during the server initialization job, is forgotten. Without this password, administrators cannot access MariaDB as root to perform required maintenance. This prevents the execution of database backups, which impacts data protection operations. If a system failure occurs before the database backup issue is resolved, the risk of data loss increases.
Solution
Stop Storware Backup and Recovery server: Stop the Storware Backup and Recovery server service to ensure no active connections are made to the database during the reset.
systemctl stop vprotect-serverStop MariaDB: Shut down the MariaDB service to prepare for a safe restart in maintenance mode.
systemctl stop mariadbStart MariaDB in unrestricted mode: Launch MariaDB with the
--skip-grant-tablesoption, allowing root access without a password.mysqld_safe --skip-grant-tables --skip-networking &Login and reset password: Connect to the local database instance and update the root user's password in the mysql system table.
mysql -u root use mysql; flush privileges; ALTER USER 'root'@'localhost' IDENTIFIED BY 'YourNewPassword'; exitRestart services: Restart MariaDB normally to re-enable security and then start the Storware Backup and Recovery server.
systemctl restart mariadb systemctl start vprotect-serverVerify access: Test the new credentials to ensure the root account is accessible.
mysql -u root -pnew-password-to-MariaDB
Keywords
MariaDB, root password, reset, Storware Backup and Recovery database backup, password recovery, database access.
Additional information
None.