Connection from Dreamweaver to Remote MySql

[paulogier]

Hi everybody,

 

I have been reading these forums and I see that a lot of people have this problem, but quite a few of the topics are really old and have not been checked in years.

 

In Dreamweaver CS3 and CS5 I have tried to connect to a remote mysql server that is running PHP 5. I can get into the server via phpMyAdmin and it works perfectly.

 

I can also type a php file and connect to the database and list the records.

 

What I can't do is get Dreamweaver to connect to the database remotely.

 

When I try it says "An unidentified error has occurred". I have read all the forums from Adobe and done all the suggestions that they have including replacing the scripts folder. I have given my IP address access to the host.

 

There is nothing else I can figure out, please help.

 

[attachment deleted by admin]

[radar]

Most MySQL servers don't allow outside connections to be made.

 

If you are running on a server with CPanel you need to enter your CPanel and turn on remote SQL from % as the host, which is a wildcard host, so that any program and/or website could then connect to your database whilst still utilizing the username and password securities.

 

If you are running under a windows based server, the default is to allow connections from anywhere i believe.  I haven't ever really used a windows server so I am unsure on this.  If you do not have CPanel, let me know what server system you have and I will figure it out for you.

 

After that you need to make sure that your dreamweaver site definitions are correct...  the main one is the testing server.. 

 

here is the way it should look:

 

•Local Info:

•Site Name: mySite

•Local Root Folder: C:\mySite\

•Remote Info:

•Access: FTP

•FTP Host: mySite.myDomain.com

•Host Directory: /htdocs/

•Login: webadmin

•Password: *********

•Testing Server:

•Server Model: PHP / MySQL

•Access: FTP

•FTP Host: mySite.myDomain.com

•Host Directory: /htdocs/

•Login: webadmin

•Password: *********

•URL Prefix: http://mySite.myDomain.com/

 

Let me know if you have any other questions or concerns