Creating a data source to an external database...

Hi folks,

I've built a couple Coldfusion / MySQL sites locally for practice, and now I'm trying to build one for real.

I'm using a GoDaddy hosting plan that comes with 10 MySQL databases. I've got a test database set up on GoDaddy's server, and I've imported three tables worth of data into it. So far so good.

Now it's time to build the site. I figured the easiest thing would be to create a Coldfusion data source connection to my database on the GoDaddy server, instead of using a local copy of my database and then somehow having to change the data source after the site is built.

Well, I can't create a working data source connection. I'm using the correct username and password, the host name I'm getting from my GoDaddy database control panel, and the default port of 3306. The Coldfusion administrator returns a long error that boils down to "connection timed out".

Now, I find this on the GoDaddy support page:
"Unfortunately, we do not allow external connections to our database servers. When connecting to a database in your Shared Hosting account, you must access it through the Database section of the Hosting Control Center."

Could that be my problem? If so... well, dumb question, but how can I create a data source that connects to the remote database, when the remote database won't accept remote connections? And if I have to build the site using a local copy of my database, no problem, but how do I make it work with the remote database when I publish??

Thanks much for any help...