- Visit the (Panel > 'Goodies' > 'MySQL Databases') page where you can find a listing of your MySQL hostnames and existing databases.
- The specific username tied to the database is listed to the right of your databases.
- Click the MySQL username.
- Click the Show button to obtain it’s password. The database’s MySQL user and password are your credentials when logging into phpMyAdmin.
- Open phpMyAdmin. Do this by opening the URL of your MySQL hostname in your browser (e.g., mysql.example.com). Or, click the phpMyAdmin link to the right of the hostname.
- This opens phpMyAdmin for your database server. A user name and password prompt appear.
You can also use the official phpMyAdmin hostname of your data center. First check the (Panel > 'Support' > 'Data Center's) page. Scroll down to locate the data center your MySQL services are located in. It's either West coast or East coast. You can then use the following hostnames to connect depending on the location of your MySQL server.
West Coast: https://west1-phpmyadmin.dreamhost.com
East Coast: https://east1-phpmyadmin.dreamhost.com
- Enter your MySQL username and password, and then click Go.
phpMyAdmin requires that the domain for your MySQL hostname is Fully Hosted and uses DreamHost's DNS. You can do this in one of two ways:
- Point your Nameservers to DreamHost, or
- Point your A record to your DreamHost IP. View the DNS article for details on how to retrieve that IP address.
If none of your hostnames are working, visit the following article on how to access the database before your DNS updates: