-1

so i already created a user on web hosting and gave it all privileges, all tables from database are working normally except my table reservation, the error says

here is where i gave all privilages on the user

"Syntax error or access violation: 1142 SELECT command denied to user 'tamayode_user'@'localhost' for table 'reservations''"

what would be its cause, im using pdo and php its different from some answers here saying i should allow all privillages because i already done that and it fully works locally but i need it to work online. i already granted or allow all privileges from the user to the database

Hephistus
  • 1
  • 1
  • Despite what you claim, it sounds like you haven't granted all privileges on the `reservations` table. Please show the output of `SHOW GRANTS FOR tamayode_user@localhost;` – Barmar Nov 10 '17 at 08:20
  • It's already answered here: https://stackoverflow.com/questions/10956195/mysql-error-1142-select-command-denied-to-user – Tegr4 Nov 10 '17 at 08:20
  • @Tegr4 i granted all privilages on the database – Hephistus Nov 10 '17 at 08:24

1 Answers1

0

I had the same problem. I just changed the port for the localhost. Try it.

lahiruhashan
  • 120
  • 1
  • 11