Overview
phpMyAdmin is a web-based tool used to manage your MySQL/MariaDB databases. You can run SQL queries, import/export data, edit tables, and troubleshoot database errors.
How to open phpMyAdmin
- Log in to DirectAdmin
- Go to Account Manager → MySQL Management
- Select any database
- Click phpMyAdmin
Login details
Use your database username and password:
Username: username_dbuser Password: your DB password Host: localhost
Common actions inside phpMyAdmin
- Import SQL backups
- Export tables
- Edit wp_options for WordPress troubleshooting
- Delete corrupted sessions
- Check database collation
Troubleshooting
- Login failed: update your DB password in DirectAdmin
- Timeout errors: export/import large SQL files via SSH instead
