Can't connect to MySQL...

[underdsea]

Hi, I need some help with connecting to my mysql database via the visual studio 2008 server explorer. it can't find the server name.
I entered the mysql-chopin.x10hosting.com and the database name/user/password and nothing...

Please help.

Thanks in advance.

 

[gomarc]

Try Server Name:"localhost"

 

[Livewire]

Try Server Name:"localhost"

Visual Studio 2008 won't run on the server - this is a home computer accessing x10's mysql from the outside.

underdsea: x10's firewall blocks all external connections to the mysql server - you won't be able to access it from visual studio. As a tradeoff though you -could- install mysql on your development system, work with it there, and when it comes time to put it on x10, export the structure/data from the database and execute it in phpMyAdmin through the cpanel, which would essentially recreate all the tables and data so it'd start working on x10 once it got moved.

 

[stpvoice]

As Livewire said, the firewall blocks external connection for security reasons.
I had this problem too initially, but got around it by changing my system to a CMS, which is pretty good at managing my site.
You could consider this, even though it's not ideal .