Jump to content

Recommended Posts

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]

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 ;)

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.