mysql error You have an error in your SQL syntax

Question

When I tried the following command to try to grant privileges, I am getting the following error, can anyone tell me why there is a syntax error?

mysql> grant all privileges on ufo.* to 'abc'@'%' identified by 'abc';




ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'abc'' at line 1

Possible duplicate of Syntax error due to using a reserved word as a table or column name in MySQL — bart
– bart, Commented Jul 19, 2019 at 18:49

ScaisEdge · Accepted Answer · 2019-07-19 18:50:53Z

1

try avoid identified by ...

grant all privileges on ufo.* to 'abc'@'%';

answered Jul 19, 2019 at 18:50

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

Collectives™ on Stack Overflow

mysql error You have an error in your SQL syntax

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related