How to Access phpMyAdmin in DirectAdmin
phpMyAdmin is a web-based tool for managing your MySQL databases. You use it to view and edit database tables, run SQL queries, import and export databases and troubleshoot database issues.
How to Open phpMyAdmin
Step 1 — Log into DirectAdmin.
Step 2 — Under Extra Features or Advanced Features, click phpMyAdmin. You can also type "phpMyAdmin" in the DirectAdmin search bar.
Step 3 — phpMyAdmin will open in a new tab. You are logged in automatically — no separate username or password is needed.
Step 4 — In the left panel you will see a list of your databases. Click a database name to expand it and see its tables.
Common Things You Can Do in phpMyAdmin
View and edit data
Click a table name in the left panel, then click Browse to see the rows of data. Click Edit on any row to change its values.
Run SQL queries
Click your database in the left panel, then click the SQL tab at the top. Type or paste your SQL query and click Go.
Export a database (backup)
Click your database in the left panel, click the Export tab, leave the format as SQL and click Go. The database will download as a .sql file.
Import a database
Click your database in the left panel, click the Import tab, click Choose File, select your .sql file and click Go. For large databases see: How to Restore a Large MySQL Database in DirectAdmin (SSH Method)
Find your WordPress database prefix
Click your WordPress database, then look at the table names. The prefix is the letters before posts — e.g. if you see wp_posts the prefix is wp_. If you see ab12_posts the prefix is ab12_. This is useful when troubleshooting WordPress issues.
Common Problems
phpMyAdmin won't open or shows a blank page
Try a different browser or clear your browser cache. If it still doesn't work, open a support ticket.
"Access denied" error
You may be trying to access a database that doesn't belong to your account. Make sure you're clicking a database listed under your own account in the left panel.
Import times out for large databases
For databases over a few MB, use the SSH terminal method instead. See: How to Restore a Large MySQL Database in DirectAdmin (SSH Method)
Need Help?
Our support team is available every day from 7am to 10pm via live chat at hostking.host or by opening a ticket at my.hostking.host.
