phpMyAdmin is a web-based database management tool included with many hosting accounts.
It allows you to manage MySQL databases directly from your browser.
This guide explains how to access phpMyAdmin using DirectAdmin.
What Is phpMyAdmin?
phpMyAdmin is commonly used to:
- manage MySQL databases
- import databases
- export backups
- edit database tables
- run SQL queries
- troubleshoot website database issues
Many applications such as WordPress rely on MySQL databases to function correctly.
Before You Start
Before accessing phpMyAdmin, make sure:
- You can log into DirectAdmin
- Your hosting account includes MySQL databases
- A database already exists on your hosting account
If you have not logged in yet, please see:
- How to Log Into DirectAdmin
Important Warning
Incorrect database changes can break websites and applications.
We strongly recommend:
- creating backups before making changes
- avoiding edits unless necessary
- contacting HostworX support if unsure
How to Access phpMyAdmin
Step 1 — Log Into DirectAdmin
Open your browser and visit:
https://cp.yourdomain.co.zaEnter your hosting username and password.
Step 2 — Open MySQL Management
From the DirectAdmin dashboard:
Click: Account Manager
Then click: Databases
Step 3 — Open phpMyAdmin
Click: phpMyAdmin (top right)
DirectAdmin will automatically log you into phpMyAdmin.
Understanding phpMyAdmin
Inside phpMyAdmin, you will see:
- Databases
- Database tables
- Import tools
- Export tools
- SQL query tools
The left-hand side normally displays your database list.
Common phpMyAdmin Tasks
Importing a Database
Useful when:
- restoring websites
- migrating WordPress sites
- importing backups
Exporting a Database Backup
Allows you to download a backup copy of your database.
Viewing Database Tables
You can view:
- WordPress content
- user accounts
- settings
- plugin data
Running SQL Queries
Advanced users may run SQL commands directly against databases.
Important Notes
Be Careful With Database Changes
Deleting or editing incorrect database data may:
- break websites
- remove content
- damage WordPress installations
Databases Power Many Websites
Applications such as:
- WordPress
- Joomla
- Magento
- online stores
all rely heavily on databases.
Backups Are Important
Always create database backups before:
- updating websites
- importing data
- running SQL queries
- modifying tables
Troubleshooting
phpMyAdmin Does Not Open
Possible causes include:
- expired login session
- browser cache problems
- temporary server issue
Try logging out and back into DirectAdmin.
Access Denied Errors
Check:
- hosting account permissions
- database ownership
- active login session
Import Failed
Possible causes include:
- database size limits
- incorrect SQL format
- corrupted backup file
- timeout limits
Large imports may require support assistance.
Website Stops Working After Database Changes
Restore a database backup if available.
If unsure, contact HostworX support before making further changes.
Security Tips
- Never share database credentials
- Keep backups regularly
- Use strong passwords
- Avoid unnecessary database modifications
- Remove unused applications and databases
