phproject icon indicating copy to clipboard operation
phproject copied to clipboard

PDOStatement: Access denied for user '

Open Backpackstudio opened this issue 6 years ago • 1 comments

An error occurs: "PDOStatement: Access denied for user '"

The cause of this error is that you are using views, but if you change database user name for some reasons, then old username is stored on view!

Backpackstudio avatar Sep 08 '19 13:09 Backpackstudio

There's not really a way for the application to solve this itself, either the definer on the views needs to match the user used in the application configuration, or the user needs to have access to other users' views (which it does by default as far as I know). I could add something to the documentation, but it's not something the application can solve itself since it's not allowed to update views it no longer owns.

Alanaktion avatar Sep 09 '19 22:09 Alanaktion