Accessing your database with phpMyAdmin
Accessing your database with phpMyAdmin
phpMyAdmin is a browser-based database management tool. Kapsule provides single sign-on access to phpMyAdmin for every website, no separate password needed.
Opening phpMyAdmin
- Go to Websites and open your site
- In the sub-navigation, go to Files → Database
- Click Open phpMyAdmin
phpMyAdmin opens in a new tab, already authenticated. You're taken directly to your site's database, no login form required.
Your database connection details
The Database page also shows your raw connection credentials if you need them for external tools (like a local database client or in your app's config):
| Field | Value |
|---|---|
| Host | 127.0.0.1:3306 |
| Database | Your database name (shown on the page) |
| Username | Your database user (shown on the page) |
| Password | Shown masked, click to reveal if needed |
Note: the host
127.0.0.1:3306is only accessible from within the server itself. To connect from your local machine, use SFTP tunnelling or a bastion host.
What you can do in phpMyAdmin
- Browse and edit table data
- Run SQL queries
- Export the database (backup)
- Import a SQL dump (restore or migrate)
- Check table structure, indexes, and relationships
- Optimise and repair tables (also available from WordPress → Database)
Importing a database
To restore or migrate a database:
- Open phpMyAdmin via the Database tab
- Click on your database name in the left panel
- Click the Import tab at the top
- Choose your SQL file and click Go
For large imports, consider splitting the SQL file into smaller chunks or using the command line via SSH.
When to use phpMyAdmin
phpMyAdmin is useful for:
- Manually editing data (fixing a broken WordPress option, for example)
- Importing/exporting a database during migration
- Diagnosing data issues
- Accessing the database when SSH access isn't available
For WordPress-specific database operations (optimise, repair, search-replace), use WordPress → Database in the site sub-navigation instead.