Overview
phpMyAdmin lets you manage your DreamHost MySQL databases from a web browser — including databases, tables, columns, relations, indexes, users, and permissions — and run any SQL statement.
Background
phpMyAdmin is software that allows you to use a web browser to manage your database. This makes it easy to perform common operations such as managing databases, tables, columns, relations, indexes, users, permissions, etc. You can also run any SQL statement within this interface.
Prerequisites
Before you use phpMyAdmin at DreamHost, you must complete the following steps:
- Add a domain as Fully Hosted or Mirrored on the Manage Websites page.
- Add a MySQL hostname on the MySQL Databases page.
- Allow enough time after adding both the hostname and full hosting for DNS to propagate.
Once you complete these steps, phpMyAdmin will be available on your domain.
How do I use phpMyAdmin?
DreamHost provides phpMyAdmin for customers on shared, Managed VPS, DreamPress, and Dedicated Server hosting plans.
How do I access phpMyAdmin?
You have two options to access:
- Use the correct hostname for your database shown in the panel (mysql.example.com)
-
Use the official phpMyAdmin hostname of your data center. This will be one of the following:
- US West: https://west1-phpmyadmin.dreamhost.com
- US East: https://east1-phpmyadmin.dreamhost.com
- EU (Netherlands): https://eu1-phpmyadmin.dreamhost.com
- AP Southeast (Singapore): https://ap1-phpmyadmin.dreamhost.com/
You can confirm which hostname to use by checking where your MySQL services are located on the Data Center page. It's either US West, US East, EU, or AP Southeast.
How do I log into my database?
See this article to learn more about how to locate your database credentials and log into phpMyAdmin.
How do I manage my database?
How do I drop or delete a database?
If you need to drop or delete a database, you must do so on the MySQL Databases page. phpMyAdmin cannot be used to perform this action.
How do I optimize a database?
Over time, the size of the database reported by phpMyAdmin will start to differ from the actual size of the database on your MySQL server's disk. This occurs because phpMyAdmin shows the database size using the database's indexes, which can be smaller than the actual disk usage after many read-write cycles.
One possible way to resolve this issue is to optimize your database, although this isn't guaranteed. The following are two methods that you can use to optimize your database: