Database access Denied --but for months prior it's been OK!

[McFrisco]

I've been working on a project for months in CS 5.5 (Windows 7 64bit.)  Yesterday my  MYSQL database connection suddenly was no good.  I've accessed the same database in 2 other applications successfully on my own computer, and tech support from my hosting company (Codero) also successfully accessed the same database at the same time, while I was on the phone.  No clues from the error message.  Its just "Access Denied."  So something is amiss, and I probably did it, and now I don't know how to get back on the rails.  It seems to be a problem specific to my installation.    Any ideas where to begin?  My installation is a fully authorized prepaid lease from Adobe, automatically updated daily via internet.

[Ben M]

First just to get it out of the way, make sure no updates or changes to the firewall have been made to block access to the mySQL server on an application level (blocking only DW).  Next if that's not the case, you may need to post more information for us to help such as your environment setup (where is the server, localhost, VPN, IP, and some of your settings - do not post username/password details for obvious security reasons). 

[McFrisco]

No Changes to Firewall.  I am the only person working on the project and the database.

[McFrisco]

I have confirmed with the site host that I am using the correct username, login, database name, and url.  I am able to connect to the same database via MySQL Workbench.  It's only Dreamweaver that will not connect.  I just get the message "an unidentified error occured."  The log is empty as well.  Any ideas would be appreciated.

[McFrisco · Accepted solution]

OK.  I figured it out. The problem was related to my use of a subdomain for a development site.    Dreamweaver finds the database's url by  from looking at the WEB url, as entered on the Server setup page, of the Site Setup dialog box.  The full path to where the site files are on the server is specified in the "Root Directory". which was set, correctly  to "/subdomains/dev/httpdocs/" Dreamweaver picks up the name of the server, "bizzocall.com/" and cocatenates it with this root directory to give you a full path name to use for FTP connections.  Where I screwed up was to use the "root directory" in the "Web URL" field as well.  I had this path set INCORRECTLY as "bizzocall.com/subdomains/dev/http/".   This caused the database url to be cocatenated like this: dev.bizzocall.com/subdomains/dev/http/" , which was redundant, and went nowhere.  When I changed the WebURL to http://dev.bizzocall.com, it worked.  I hope this little exercise is of use to somebody!  :<)McFrisco