Setting up MySQL with godaddy as my domain host


#1

Hello,

I’m having a little trouble setting up my MySQL on dreamhost’s servers.

SQL Error: (2003): Can’t connect to MySQL server.

Just to give a little background on my setup. I have godaddy hosting my domain name. I have the nameserver forwarded correctly (website are displaying the stuff right) I have a CNAME mysql.domain.com pointing to @ and A (Host) @ forward to my dreamhost IP.

I want to say it has something to do with my link between godaddy and dreamhost but I don’t know what to change to get it to work correctly.

If anyone has any information that would be great.

Thanks,
Throdne


#2

The MySQL server is probably not on your “dreamhost IP”. Are you really using the DreamHost nameservers, or only creating DNS records at GoDaddy?


#3

Thanks for the reply,

I have all three nameservers set on go daddy’s side. On the cname I have MySQL set to value"@" and on the A (host) I have the “@” pointing to the ip of my dreamboat server. The domain, and all sub-domain work. I just can’t get any connection to my MySQL on dreamhost side.

Throdne


#4

That configuration will not work. DreamHost MySQL does not use the same IP address as your web site.


#5

Any idea on how I’m going to get it to work?


#6

Panel > Domains > Manage Domanis

Click Add New Domain / Sub-Domain

  • Create a [some_random_string].dreamhosters.com sub-domain

Panel > Goodies > MySQL Databases

  • Click the Add New Hostname button

  • Type a [prefix] in the box, select [some_random_string].dreamhosters.com from the dropdown and click Create this MySQL hostname now!

Use [color=#3333FF][prefix].[some_random_string].dreamhosters.com[/color] as the db host in your config files.


#7

Thanks, Do I need to edit anything on my godaddy side, CNAME, A (Host)… because it currently have it set up like this:

Did your set up guide.
CNAME: server.domain.com VALUE @
A (Host): @ VALUE IP of server.

Or do I need to delete CNAME and make only a A (Host) for it?


#8

If you’ve set the DreamHost nameservers over at GoDaddy then there’s no need to touch anything over there.