I'm curious how do I use a sub-domain for my MySQL database server? So far I've only used "localhost" for my database server name, but if I wanted to use sub-domain names instead, how would I do this?
So far I figured it's probably the same as using a DNS service like Zoneedit.com as I do for my domain names to send them to my IP for my websites, but what else do I need to know.
Do I need to configure port forwarding for the DNS, such as have the DNS direct it to my IP AND port 3306 or whichever port my SQL server is running on? And is there any other settings I need to adjust, such as in my.ini or anything?
The example is I've been using bravehost.com as my paid hosting provider for some years now and they have 10 sql database servers, sql1.bravehost.com, sql2.bravehost.com, and so on. Something like that is what I'd like to replicate with a single sql server.
Thanks in advance!