"Syntax error or access violation: 1142" in Symfony and MySQL

Question

I am creating an API REST aplication with Symfony3, and I have this problem. When I execute the methods in localhost it works fine, but I have uploaded the project to a server administered with Plesk, and when I try to execute the methods with postman, it shows this:

An exception occurred while executing 'SELECT t0.random_id AS ...' with params [\"a\", \"a\"]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'app'@'localhost' for table 'table_name'

It seems to be a permissions problem, but if I try to access to the database with MysQL Workbech, with the same credentials, I can do it and execute querys without problems. And in the Plesk panel, the user has all the permissions and privileges.

I have also tried changing "localhost" for the host address in the parameters file of Symfony.

post the code always

Abdulla Nilam
– Abdulla Nilam

2017-10-19 07:54:19 +00:00
Commented Oct 19, 2017 at 7:54 — Abdulla Nilam
– Abdulla Nilam, Commented Oct 19, 2017 at 7:54

Łukasz D. Tulikowski · Accepted Answer · 2017-10-19 10:51:47Z

1

Looks like app user doesn't have permissions to execute SELECT query.

Run following MySQL query to fix it:

GRANT SELECT on database_name.* to 'app'@'localhost' identified by 'your-pass';
FLUSH PRIVILEGES;

answered Oct 19, 2017 at 10:51

Łukasz D. Tulikowski

1

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

"Syntax error or access violation: 1142" in Symfony and MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related