I'm using mysql, php and phpmyadmin on Windows server 2003...web edition.
I've sert it up to allow php scripts to run, and phpmyadmin connects to the sql server fine, but when i try and make a sql connection in Dreamweaver, the server returns an error message. Something like.....steve@localhost Using password = yes blah blah blah error 1045.
I've read this around these forums, but never seemed to find an appropiate answer. Like i said....Phpmyadmin works fine, and i can run php scripts on it, it's just when i try and access the database it blocks me. I am entering the correct username and password, and i have full privileges.
Just had the same problem for over a week and finally had the ISP guys visit the office to resolve.
After 2 hours it turned out to be a problem with the password. They had used a random password generator that had generated a password with the '+' symbol in it. This worked fine accessing phpMyAdmin page via browser, but not when trying to set up connection via dreamweaver.
Anyway check your passwords and if necessary get them changed!