Been struggling with the mysql password problems recently, mainly the 1045's access denied alerts for user@localhost. I'm pretty sure everyone deals with these sooner or later, right?
I finally got the phpmyadmin config edited and the root-user password reset and while phpmyadmin has worked a treat since then, I can't seem to get DW CS4 to connect to a database i created for the very purpose. It should be walk in the park, agreed; been doing it since way back, but then this isn't the only symptom of connectivity problems... Out of the five or so shoutboxes I've messed around with over the last week, only one has functioned properly. I get weird access denied alerts or just plain nada in the case of a php + ajax solution: yshout - is ajax supposed to work on xampp 1.7.3?
I've tried chmodding the lot of files to no avail, and I've checked and rechecked for typos. Turning off my malware defences didn't help either.
To specify: I've changed the root mysql password and phpmyadmin is much to my delight accepting both it and a database specific user I created for testing purposes and which I'm trying to use to connect to my db, but dreamweaver isn't playing along, all while the root-user should have full privileges. All I get is a #1045 access denied error when I try to test the MySQL connection. What could I possibly be doing wrong? Getting up in the morning? Yea, but besides that?
Is there some common denominator to find among these symptoms? Feel free to school me.
Specs:
OS: win7, 64bit
server: xampp win32 1.7.3