DW8 frustrating mysql access error

Question

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 · Answer

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.