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](https://stackoverflow.com/questions/23446377/syntax-error-due-to-using-a-reserved-word-as-a-table-or-column-name-in-mysql) — bart, Jul 19 '19 at 18:49

score 1 · Accepted Answer · answered Jul 19 '19 at 18:50

1

try avoid identified by ...

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

answered Jul 19 '19 at 18:50

ScaisEdge

131,976
10
91
107

mysql error You have an error in your SQL syntax

1 Answers1