MySQL Databases

This page explains the MySQL Databases screen in GoAdmio. It is the central place to create, manage, and delete MySQL/MariaDB databases and database users for every domain on the server.

Location: Admin Panel → Databases → MySQL Databases
Location (User Panel): Databases → MySQL Databases

Overview

GoAdmio runs MariaDB/MySQL as its database server. Every hosting account can create databases and database users, and the MySQL Databases page is where those are managed.

Each database in GoAdmio is prefixed with the account username to avoid naming collisions across the server. For example, an account with username bedorandsheroq creates databases named bedorandsheroq_<name> and users named bedorandsheroq_<user>. This is the same convention used by cPanel and is critical for multi-tenant isolation.

The page lets you:

• Create databases and database users
• Assign users to databases with specific privileges
• Generate strong passwords
• Access phpMyAdmin for a database
• Create a snapshot of a database
• Search existing databases and users
• Delete databases and users
• Repair databases (see Repair MySQL Database)

What the Page Shows

| Field / Column | Description |
|---|---|
| Domain | The hosting account/domain the database belongs to |
| Database Name | The full database name, prefixed with the account username (e.g., bedorandsheroq_) |
| Database Username | The full username, prefixed with the account username (e.g., bedorandsheroq_) |
| Password | The database user's password, with a Generate Password button |
| Search | Filter the list of existing databases and users |
| Create | Create a new database and/or user |
| Snapshot | Create a point-in-time snapshot of a database |
| phpMyAdmin | Open phpMyAdmin for a database |

> Tip: The prefix is set automatically based on the selected domain's username. You only type the suffix (e.g., wordpress → full name bedorandsheroq_wordpress).

How to Create a Database

Via the Admin Panel

1. Log in to the GoAdmio Admin Panel (or User Panel).
2. Navigate to Databases → MySQL Databases.
3. Under Create, select the Domain from the dropdown.
4. Enter the Database Name suffix (e.g., wordpress). The full name becomes bedorandsheroq_wordpress.
5. Enter the Database Username suffix (e.g., wpuser). The full username becomes bedorandsheroq_wpuser.
6. Click Generate Password (recommended) or enter your own password.
7. Click Create (or Create Database).

> Warning: Save the password immediately — it is not displayed again after creation. Store it in a password manager or in the application's configuration file. If you lose it, you must reset it (see Reset a Database User Password).

Via CLI

```bash

Create a database

Create a user and grant privileges