Connectiong to MySQL with Dreamweaver CS3

[gamerdude]

Connecting to MySQL with Dreamweaver CS3

I am having problems connecting to my MySQL database remotely using Dreamweaver. How should I connect to it, set it up, etc.

 

[TechAsh]

I don't think it is possible. x10 doesn't allow remote connections to the MySQL databases.

 

[francoisvdv]

Why is there an Remote MySql option in the CPanel then?

 

[tnl2k7]

Because that allows your x10Hosting account to connect to other servers to allow you to use databases not on your server. It was set up ages ago when we moved MySQL databases to a new server (mysql.x10hosting.com) but it didn't work, so things have been moved back. I'd leave that tool alone unless you speak to Bryon or Corey about using it .

-Luke.

 

[francoisvdv]

Hi Luke, thanks for your reply :biggrin:

I already have my site set up so that it connects to a database outside of x10. Link. I set the wildcard in the remote mysql area.

I hope that isn't a problem, because it is working like a charm

One more thing though; I can also access the database through my own computer's MySql administration tool. Is it ok if I use that? Because elsewhere on the forum I read that Corey must open up the firewall, but it is already working for me.

 

[tnl2k7]

I don't think that should be open, as people could potentially abuse this; using x10Hosting as a MySQL database host and not doing anything useful with their hosting account. It also opens up the possibility of somebody obtaining copies of databases they shouldn't have access to as well.

Not too sure, but your thread in the Free Hosting forum will get a response from one of the administrators; who know more about that side of things.

-Luke.

 

[laethyn]

To dig up an old thread ..

When connecting to mysql through Dreamweaver, you are not connecting from outside of your hosting. Dreamweaver uploads a connection file to your host which then accesses the db and hands the data back into Dreamweaver.