KB10002 Reset MariaDB root password for vProtect database backups

📚

Documentation

Installation guides, configuration steps, and product documentation.

Explore documentation →

🎧

Support

Create a support request or review your existing cases.

Go to support →

⬇️

Download trial

Download the product trial and try it out.

View downloads →

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

  1. 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-server
  2. Stop MariaDB: Shut down the MariaDB service to prepare for a safe restart in maintenance mode.

    systemctl stop mariadb
  3. Start MariaDB in unrestricted mode: Launch MariaDB with the --skip-grant-tables option, allowing root access without a password.

    mysqld_safe --skip-grant-tables --skip-networking &
  4. 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'; exit
  5. Restart services: Restart MariaDB normally to re-enable security and then start the Storware Backup and Recovery server.

    systemctl restart mariadb systemctl start vprotect-server
  6. Verify 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.