Finding your database login credentials

Overview

Your database credentials allow you to log into your database in the panel using phpMyAdmin. phpMyAdmin is a graphical interface where you can navigate through your database and make changes.

These same credentials can also be used to connect to the database using any software you like.

Make sure you only log into your database only if you know exactly what you need to adjust. Any misconfiguration in your database could potentially cause your site to not operate properly.

A note about DNS settings

If your DNS is hosted with DreamHost

If your nameservers are hosted at DreamHost, proceed with the steps below.

If you just installed WordPress using the DreamHost WordPress installer

If you just installed WordPress using the DreamHost WordPress installer (and your nameservers are pointed to DreamHost), you will need to wait a few hours for the new mysql subdomain to update. Once the DNS has propagated online, your site will connect to your database.

If your DNS is NOT hosted with DreamHost

If your nameservers are NOT pointed to DreamHost, you must create an A record (at your current hosting company) for your mysql.example.com hostname. This must point to your DreamHost mysql A record. Only after this A record updates online would the phpMyAdmin link in your panel function.

View the following article for instructions on how to locate your DreamHost mysql A record. You can then contact your current hosting company to add it to their system.

You only need to create the A record for your mysql subdomain such as mysql.example.com.

Alternatively, you can use the East and West coast data center hostnames under Step #4 below to log in.

Step 1  Find your database name

Visit the MySQL Databases page and scroll down to the section titled Databases on this server. Below you'll see a listing of your databases.

If you have multiple databases, you'll need to identify the one that corresponds to your website. This can usually be found in the site's configuration file, but every application puts this in a different location. Consult your application's knowledge base for configuration file locations. Make a note of the database name.

Step 2 — Find your username

The specific username tied to the database is listed to the right of your databases. Make a note of this.

Step 3 — Find your password

Click the username under the USERS ACCESS column. On the next page, click the Show button to view the user's password. Make a note of this.

Step 4 — Find your hostname

Navigate back to the MySQL Databases page. Near the top you'll see a section titled HOSTNAME. Look for the hostname that corresponds to your website. It most likely has the website's name in it.

To the right of the hostname is a link titled phpMyAdmin. Click this link to open the phpMyAdmin login page.

You can also use the official phpMyAdmin hostname of your data center. First, check the Data Center 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.

Log into phpMyAdmin

In the phpMyAdmin prompt, enter your hostname, username, password, and click Log In.

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:

If none of your hostnames are working, visit the following article on how to access the database before your DNS updates:

See also

Did this article answer your questions?

Article last updated PST.

Still not finding what you're looking for?