phpMyAdmin

This page explains how to access phpMyAdmin in GoAdmio. phpMyAdmin is a web-based tool for managing MySQL/MariaDB databases — browsing tables, running SQL queries, importing/exporting data, and repairing tables.

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

Overview

GoAdmio includes phpMyAdmin as a built-in database management tool. It connects to the server's MariaDB/MySQL instance and lets you manage databases through a browser — no command line required.

There are two ways to open it:

1. Directly from the Databases menu (general phpMyAdmin login)
2. Pre-authenticated by clicking phpMyAdmin next to a database on the MySQL Databases page

How to Access phpMyAdmin

Option 1 — From the MySQL Databases page (recommended)

1. Log in to the GoAdmio Admin Panel (or User Panel).
2. Navigate to Databases → MySQL Databases.
3. Locate the database you want to manage.
4. Click phpMyAdmin next to it.

Option 2 — From the Databases menu

1. Log in to the GoAdmio Admin Panel (or User Panel).
2. Navigate to Databases → phpMyAdmin.
3. Enter the database username (e.g., bedorandsheroq_wpuser).
4. Enter the database password.
5. Click Log in (or Go).

Logging In

When phpMyAdmin prompts for credentials:

| Field | Value |
|---|---|
| Username | The database user (e.g., bedorandsheroq_wpuser) |
| Password | The database user's password |
| Server Choice | Leave as default (localhost) |

> Warning: If you get "Access denied", the user is either not assigned to any database, the password is wrong, or the user has no privileges. Check the user's assignment and privileges in MySQL Databases.

What You Can Do in phpMyAdmin

Once logged in, the common tasks are:

| Task | Where in phpMyAdmin |
|---|---|
| Browse a table | Left sidebar → select table → Browse |
| Run SQL | Top menu → SQL tab |
| Import a .sql dump | Select database → Import tab |
| Export a database | Select database → Export tab |
| Repair a table | Select table → Operations → Repair table |
| Optimize a table | Select table → Operations → Optimize table |
| Manage users | User accounts tab (requires privileges) |
| Change a password | User accounts tab → edit user |

> Tip: For importing large .sql files, use the Import SQL File page instead — phpMyAdmin may time out on very large imports.

Related Tools

GoAdmio also provides:

| Tool | Purpose |
|---|---|
| Adminer | Lightweight alternative to phpMyAdmin — single PHP file, faster for simple tasks |
| Import SQL File | Import large .sql dumps outside phpMyAdmin |
| Repair MySQL Database | Repair corrupted tables without phpMyAdmin |
| MySQL Databases | Create/delete databases and users, manage privileges |

Related Pages

• MySQL Databases — create and manage databases and users
• Adminer — lightweight database manager alternative
• Repair MySQL Database — fix corrupted tables
• Import SQL File — import large SQL dumps
• MySQL Root Password — change the MySQL root password
• Database Map Tool — map old database names
• SQLite — SQLite database management
• Query Top — identify slow queries
• MySQL Top — currently running queries
• Add Missing Indexes — performance tuning

Troubleshooting

| Problem | Likely cause | Solution |
|---|---|---|
| "Access denied" on login | Wrong username/password, or user has no privileges | Reset the password in MySQL Databases; verify privileges |
| phpMyAdmin does not load | PHP or web server issue | Check Service Status; rebuild config with /go/conf |
| Cannot see a database | The logged-in user is not assigned to it | Log in as the database's user, or grant access in MySQL Databases |
| Timeout on large import | phpMyAdmin import limits | Use Import SQL File or the CLI instead |
| "No privileges" when browsing | User has limited privileges | Log in as a user with ALL PRIVILEGES on that database |
| Session expires quickly | phpMyAdmin session timeout | Log in again; for long operations, use the CLI |
| Cannot edit data in a table | Table is read-only, or user lacks UPDATE | Verify the user's privileges in MySQL Databases |