MySQL Host Name doubts?


#1

Hi, I am not new to hosting but when I switched to dreamhost I am confused with the term “mysql host name”.

Do I have to create a separate subdomain through my domain control panel ( i use godaddy) and set its DNS records to dreamhost’s. And use this subdomain as a mysql subdomain?. Do I have to do it for every domain I add in my dreamhost panel?. Or is this “mysql subdomain” is just a virtual name assigned by dh panel.

I had to cancel my account as I could not setup my rails application to use mysql db. Any help would make me a customer again.

Thanks


#2

when you create a mysql database you must have a host name to access it with. you do not need to create multiple host names if you do not want to as they are interchangeable. some people just find it preferable to have a host name for for database ‘A’ that is used by whatever.com be mysql.whatever.com and for database ‘B’ being used by somethingelse.com to be mysql.somethingelse.com. It is all about appearances really since both database ‘A’ and ‘B’ can both be accessed by going to mysql.whatever.com or mysql.somethingelse.com.

You need not change any of the dns settings for the subdomain. You can either use an existing hostname (that you created when you were creating one database) or make up a new one with the domain of your choosing – when you create another database (that is already being pointed to DH servers).

http://www.marciesgifts.com
PM for custom CMS(drupal,joomla,etc)/Blog(WP,MT,etc
)/forum(phpbb,smf,etc) install/transfer $75.
[color=#CC0000]$25 Off[/color] w/promo code SPRINKLES


#3

hi thanks

Just to make it clear for myself, I am summarizing my understanding. Please confirm.

  1. Let us say i have domains 123.com, abc.com, xyz.com. I will be using only abc.com and xyz.com for hosting. 123.com will be used for creating subdomain for mysql.
  2. So, I will create a subdomain mysql.123.com in my domain registrar control panel and provide the DNS of dreamhost.
  3. In my dreamhost web panel, i can use mysql.123.com as my mysql domain for all my mysql applications of abc.com and xyz.com, each having different databases.

is this correct?


#4

If you like, sure. The only requirement for a MySQL host name is that it must be under a domain which you own, and which is pointed at DreamHost’s name servers. It can even be a dreamhosters.com subdomain if you like.