Forums

MySQL permission

I have set up a MYSQL database, I am sure I have all the details correct but I keep getting (1142, "SELECT command denied to user '{username}'@'{ip}' for table 'entries'"). I can't make changes to permissions it seems so I am not sure how to fix this.

Any help is appreciated.

Just to be certain I used the same information that is being used on the site into workbench and it connected. So the details are correct. There is just some permission issue.

nvm.... got it, I was writing a query as databasename.tablename and not username$databasename.tablename.

Glad to hear that you made it work!