database connection and GODADDY

does any one knows how to connect to a godaddy database from dreamweaver?

So far I have done all the steps by all the extensions from webassist. I have tested locally and work great, but at the moment I want to connect to my data base at godaddy I have and 403 error show up.

I have check my user, etc etc and still the same problem!!

Any help will be appreciated.

2 long days, a lot of caffeine, 4 hours of sleep and having dreams about dreamweaver CS4 database connection with GODADDY!!!

Priceless!!! I DONT THINK SO!!!!!

Any way, Being reading forums, articles, etc etc and not luck!
I still have same error showing up 403 in one of my databases and 404 with another one.

Any way, Any one that has the same problem with godaddy database connection and found out how to make it work! my respect, but please can you give a hand I dont want to have gray hair before my 40's.

I can log in to mySQL and load my tables, etc, etc, but I cannot connect from dreamweaver to mySQL.

Please, I dont want to drink more caffeine.

GoDaddy's MySQL servers do not allow connections from an outside server.

You will not be able to create a connection to the go daddy server through Dreamweaver.

It is a better practice to install a local php/mysql server for testing and development, then upload the files to the remote server, change the database connection details with the correct information for the Godaddy server for deployment.

See the learning resources page:
resources.php


for tutorials on installing a local testing server and defining a dynamic site in Dreamweaver

I have installed the XAMP in my computer, etc, etc.

So I just need to put all my files in the godaddy server and then insert all my product from internet?

Thank you for your response!

an one more question:

Which hosting service will you recommend to work with dreamweaver and webassist extensions instead godaddy?

The best work flow is to develop the application locally, once complete, uplaod all of the files to the remote server, create the database on the remote hosts MySQL server, and modify the connection file to connect to the remote MySQL server.

Thx for the advise.

I will do that and probably I will have more question later on, but so far
looks good to do it!

you're welcome.

jeda,

I, too, agree with Jason about developing locally and then uploading. But, with that said, I actually like for my host to provide me with the ability to have a remote connection so I can use a database management tool on my machine to manage the database.

Typically, some hosts will allow you to add your IP to your hosts database server to allow your machine remote access. I find this to be the ideal setup, especially if the host uses the typical "localhost" configuration. You can then create your machine's testing server DBs all to configure to localhost and exactly mirror the online DB. Then after getting your application running well on your testing box, just be sure to export the data and then import it onto the online DB, upload your files, and your good to go.

If you're looking for a good host to do this, there are several out there. I have had great experience with Site5 (their customer support has been great for me) and Little Oak.

Best regards,

Brian

Sojo,

I will take that in mind. I am being looking for hosting services that supports dreamweaver database connections and always is good to hear from someone what hosting is good to work on it.

I will check prices and once again thank you so much for the advise.

Just one last think

Do you know anything about hostgator?

I don't know too much about them from a personal experience side. I did almost get an account with them before going with Site5. I am extremely thrilled with site5's HostPro+Turbo plan. They have a custom admin that they created that makes it super easy to add new sites and manage them separately. And for 11.95 a month with everything unlimited (and their resource limits aren't unreasonable either), it's been the best deal I have found for some recent extra space I needed. The thing I really love though is that every time I have submitted a support tickets for help, they respond almost within 5 minutes and help me right away - so for that, they get my vote. I do know that Host Gator does have their servers in the same place as Site5, though, which is a facility known as "the Planet".

Best regards,

Brian