close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

MySQL Connection Won't Connect

Thread began 3/01/2010 2:30 pm by webassist2366041 | Last modified 3/02/2010 1:27 pm by Eric Mittman | 930 views | 1 replies |

webassist2366041

MySQL Connection Won't Connect

Mac OS 10.5.8 and Dreamweaver CS3 with User Registration Solution Pack

I've set up a database and uploaded the empty table.

In Dreamweaver, I opened the "Database" window and opened the "MySQL Connection." I filled out the connection name, used the server's IP address for the "MySQL server," and put in the user name, password, and database name.

When I clicked the button to test it, a window popped up and said, "An unidentified error has occurred."

I tried clicking the "Select" button beside the "Database" field (which I filled out), but it said the same error.

I spoke to tech support at my hosting company. He tested it for firewalls, put in my computer's IP address for access, and allowed universal access, but I still received the same error every time.

I gave him the exact information that I used in the fields (including the IP of the server) and he connected.

A couple of days later, I called my host again. This time, a different tech support guy and his supervisor tried all of the same steps. They confirmed that they could get access, but I still couldn't.

What should I do?

Sign in to reply to this post

Eric Mittman

Unfortunately the unidentified error is a problem that occurs from time to time when creating a connection inside of DW. To try and resolve the issue you should make sure to delete your connection from within DW. Next you should clear the cache file for DW with these instructions:

common_installation_issues.pdf

It would also be worth deleting your _mmServerScripts folder from your site root in case there is any bad connection info in there. Once you have done these things try creating the connection again and testing it. When it comes to the db name try entering one in rather than using the select button.

Also, you should confirm with your host that remote access is allowed for connecting with the MySQL db. It is very common to disable remote access and force only local access to the MySQL server. It seems like you host may have it setup for you to access based on what you posted here but it is something else to check.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...