Category: Web Development

This content is taken directly from Dreamhost's DNS – Accessing your Database before DNS change wiki article. It's a fantastic way to open a back door to a site under development and demo it to a client while you work on development.

---

To access your SQL database, you need a unique hostname (domain name) for your MySQL server. This can be any name you wish, so long as you have registered it, but it is commonly a sub-domain of "yourdomain.com" called "mysql.yourdomain.com". This arrangement is convenient to use with DreamHost's MySQL installations, as the servers can be created and managed all from within DreamHost Web Panel > Goodies > Manage MySQL.

However, during a server or host migration, the registration entries for "yourdomain.com" may not point to DreamHost's name servers, so you wouldn't be able to use a sub-domain of "yourdomain.com" for the MySQL hostname.

With DreamHost's setup, your MySQL server (which hosts all of your databases) is accessible from any domain or sub-domain that you assign to it. So you can still access your DreamHost-hosted MySQL database by assigning it a temporary subdomain which points to DreamHost. And that's easy to do.

Add a sub-domain

Add a free dreamhosters.com sub-domain at DreamHost Web Panel > Domains > Manage Domains > Add Domain / Sub-domain [1], scroll down to the "Mirrored" section, and create a mirror of "yourdomain.com" named "yourdomain.dreamhosters.com". Make sure to leave ".com" or ".net" out of the middle of this sub-domain name.

Add a MySQL hostname

Then add a hostname for your MySQL server to your new subdomain, with DreamHost Web Panel > Goodies > Manage MySql > Add New Hostname. Enter the hostname of your choice (commonly "mysql"), and select the new sub-domain using the dropdown menu.

So if your domain is "yourdomain.net" and your MySQL hostname is "mysql", your new sub-domain will be "yourdomain.dreamhosters.com" and the SQL hostname will be "mysql.yourdomain.dreamhosters.com".

Access the database with phpMyAdmin

Once the DNS changes propagate, you will be able to access the phpMyAdmin SQL management utility at "mysql.yourdomain.dreamhosters.com", using the SQL server login information you specified when you set up the MySQL server on the DreamHost panel. Or, assuming your sub-domain is up and running, you can access the admin app right away by pointing your browser to http://yourdomain.dreamhosters.com/dh_phpmyadmin/mysql.yourdomain.dreamhosters.com.

If you try to access phpMyAdmin before the sub-domain's DNS records have changed, dreamhosters.com's phpMyAdmin interface will be unable to recognize your login information; this does not mean your installation is broken, just that DreamHost can't yet access your sub-domain.

See also DNS_-_Viewing_site_before_DNS_change

Unfortunately, people often fail to realize that domain names are an important intellectual property asset, or at the very least should be treated that way.

Ask yourself these questions;

Do you understand exactly what an Internet domain registration is?  Do you know who controls your domain registration?  Do you know in exactly what name your domain is registered?  Do you know what email address was provided to the registrar as a contact?  Do you know where to find the usernames and passwords for all the computer accounts associated with your domain and website hosting?  Do you know when your domain registration expires? Did you know that if someone else, like your web hosting company, was registered as the owner, you have absolutely no rights to your domain?

If the answer to even one of those questions is no, you need to take action!

Your domain registration is essentially your entry in the ‘phone book’ of the Internet.  If you lose control of it, or let it expire, there's a strong chance you will not be able to get it back.

Here are a few tips that will help you avoid losing your domain name.

• Register your domain in the name of the organization, not any individual.
• Create a separate account at the domain registrar / ISP for the organization.  Don't lump it in with the webmaster's other domains on one registrar account, even if you are listed as the domain owner.
• Prepare an  envelope containing the registration details and the account names and passwords for your registrar and web host (ISP).  Place the envelope in a safe place with your other important personal or business papers.  This is an asset!
• Establish a reliable tickler system to ensure that the registration is renewed annually well in advance of the deadline.
• Confirm annually that the email address on file with the domain registrar is valid.  This is the address they will send reminders to when the registration is due!
• I register all my domains annually rather than taking a small discount for longer registrations.  I'm more likely to lose track of registrations if multiple years go by.
• Seriously consider registering at a registrar that does not do your hosting, or moving then to another registrar if they’re together now.  That way, if you have a dispute with your ISP over hosting, they have no control over domain and you can simply walk away with your backups and set up elsewhere.  Many people have lost their domains because the ISP refused to release them.

Remember that the price you pay for domain registration is not significant.  $10 – $20 – $30 per year is irrelevant given what is at stake.  Choose your domain registrar on reputation and reliability, not price.  I pay about twice the rate available from the big operators to register with a small operator with a good reputation.

You can use http://www.easywhois.com to check when your domain registration is going to expire.  Depending on how the registration was processed, it may also tell you who the registered owner is.

---