DW8 frustrating mysql access error

[dean2]

I have a frustrating situation. I set up a database in DW8 - testing it shows that it connects successfully. Deploying phpMyAdmin (same host, same UN/PW/database) is also successful. But when I try to connect to the pages, or even try to load Connections/connectionname.php directly, I get

Fatal error: Access denied for user 'user'@'hostname' (using password: YES) in C:\Inetpub\ftproot\rest-of-my-path\Connections\connectionname.php on line 9

anyone else? any thoughts?

[dean2]

For clarification, I changed the user, host and connection name above - the real errors involve actual usernames, etc.

[dean2]

OK - sorry for the interruption - turns out this was a mySQL issue, rather than a DW one.

For some reason, even though I dropped the schema, and dropped the user, if I recreate the user it would not pick up the new permissions I assign to it. Why it would work remotely through DW, and locally through phpMyAdmin, but not from a web page is still a mystery to me, but I was able to resolve it by creating a brand new user with a unique name, and assigning it the same priviledges that I _thought_ I was assigning the other user.

hmmm... but I get to move on with my life, at least.

Dean