MariaDB: Restoring the root user and permissions

This documentation is part of the Troubleshooting guide. View the full guide here: Common MariaDB issues and their solutions.

👋 Welcome to Stackhero documentation

Stackhero provides a ready-to-use MariaDB cloud service designed for production workloads. You get:

• Unlimited connections and data transfers.
• Built-in phpMyAdmin web interface for database management.
• One-click updates for easy maintenance.
• High performance and strong security on private, dedicated infrastructure.

Launch a fully managed MariaDB instance in minutes. Stackhero handles setup, updates, and security so you can focus on your application. Learn more about MariaDB cloud hosting.

If you find that the root user has been removed or its permissions or password altered unintentionally, you can restore it by restarting the MariaDB instance. Doing so reinstates the root user along with its default permissions and password.