MySQL Root Password

This page explains the MySQL Root Password screen in GoAdmio. It lets you change the password for the MySQL/MariaDB root user — the database server's superuser account — and keep GoAdmio's stored copy in sync.

Location: Admin Panel → Databases → MySQL Root Password

Overview

The MySQL root user is the database server's superuser. It has unrestricted access to every database, every user, and every server-level operation (creating users, granting privileges, changing server variables, shutting down the database). It is not the same as the Linux root user, and it is not the GoAdmio panel admin.

GoAdmio stores the MySQL root password so it can perform privileged database operations on your behalf — creating databases, managing users, running repairs, taking snapshots. When you change the MySQL root password through this page, GoAdmio updates its stored copy automatically.

> Warning: If you change the MySQL root password outside GoAdmio (e.g., with ALTER USER or mysqladmin over SSH), GoAdmio's stored copy becomes stale and database operations in the panel will fail with "Access denied for user 'root'". Always use this page, or update the stored password afterward.

What the Page Shows

| Field | Description |
|---|---|
| Current Password | The existing MySQL root password (may be required for verification) |
| New Password | The new password for the MySQL root user |
| Confirm Password | Re-enter the new password to confirm |
| Generate Password | Button to generate a strong random password |
| Save / Change | Apply the change |

> Tip: The MySQL root password is a server-level credential. Treat it like the Linux root password — store it in a password manager, rotate it on a schedule, and never share it with customers.

How to Change the MySQL Root Password

Via the Admin Panel

Log in to the GoAdmio Admin Panel.
Navigate to Databases → MySQL Root Password.
Enter the current password (if prompted).
Click Generate Password (recommended) or enter a new strong password.
Re-enter the new password to confirm.
Click Save (or Change Password).

GoAdmio updates the MySQL root password and its own stored copy in one operation. No service restart is required.

Via CLI

If you change the password from a root shell, use one of these methods:

```bash

Method 1: mysqladmin (requires the current password)

mysqladmin -u root -p'OldPassword' password 'NewPassword'

Method 2: ALTER USER (MariaDB 10.4+ / MySQL 5.7+)

mariadb -u root -p

then at the MariaDB prompt:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword'; FLUSH PRIVILEGES;