Managing MySQL Databases with phpMyAdmin in DirectAdmin #
phpMyAdmin is a web-based tool for managing your MySQL databases — browsing tables, running SQL queries, and importing or exporting data — all without needing a separate database client installed on your computer. DirectAdmin gives you one-click access to phpMyAdmin for any database on your account.
Don’t have a database yet? See how to create a MySQL database in DirectAdmin first.
How to Access phpMyAdmin #
- Log in to your DirectAdmin control panel by accessing https://yourdomain:2222
- Navigate to Databases (under Account Management).
- Find the database you want to manage and click its phpMyAdmin link/icon.
- phpMyAdmin opens in a new tab, already logged in — no separate database username or password is needed.
Common Tasks in phpMyAdmin #
- Browse and edit data: click a table name in the left sidebar to view its rows; use the Browse, Edit, and Delete buttons next to any row to make changes directly.
- Run a SQL query: click the SQL tab to write and execute custom queries against your database.
- Import data: click Import, then upload a `.sql` file to load data or restore a table structure — useful when migrating a site or restoring from a backup.
- Export data: click Export to download your database (or specific tables) as a `.sql` file — handy for backups or moving to another environment.
- Create or modify tables: use the Structure tab to add, edit, or remove columns and indexes.
Before You Make Changes #
Editing a live database can break your website if done incorrectly. Before running queries or imports, make sure you have a current website backup — database backups are included when you select “Databases” in the backup options.
