How do I access my database before a DNS change?

To access your MySQL database, you need a unique hostname (domain name) or IP address for your MySQL server. This hostname can be any name you wish, so long as you have registered it, but it is commonly a subdomain of your primary domain and is named "mysql.example.TLD".

For example, let’s say your domain is example.com: you can then create the subdomain "mysql.example.com" which is used to connect to your database server.

This arrangement is convenient to use with DreamHost's MySQL installations, as you can create and manage all of your databases from the (Panel > 'Goodies' > 'MySQL Databases') page.

What hostname should be used if DNS is not yet pointed to DreamHost?

During a server or web host migration, the DNS for "example.tld" may not point to DreamHost's nameservers, so you won't be able to use "mysql.example.tld" for the MySQL hostname.

If you have other domains hosted at DreamHost, you can use their hostname instead. This is because your MySQL server (which hosts all of your databases) is accessible from any subdomain that you assign to it within your DreamHost account. 

For example, if you have another domain like 'dreamhostexample.com' and its nameservers are pointed to DreamHost, you could create a mysql hostname titled mysql.dreamhostexample.com. You can then use this hostname to connect to ANY database in your DreamHost account.

What if I do not have any domains pointed to DreamHost?

If you do not have any domains hosted at DreamHost, you can still connect to your database. To do this, you must add a free dreamhosters.com subdomain. It would appear like 'example.dreamhosters.com'. You can then create a mysql hostname such as 'mysql.example.dreamhosters.com'. View the following article for instructions on how to create this subdomain.

 

Did this article answer your questions?

Article last updated .