Search code examples
mysqlprivileges

MySQL ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

When I tried to grant privileges on users at mySQL, the error happened.Am I type something wrong on the command line?

mySQL Ver 8.0.16 for macos10.14 on x86_64 (MySQL Community Server - GPL).

mysql>grant all privileges on librarydb.* to 'phill'@'%' identified by '123456';

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 '123456'' at line 1.
Solution

  • What version is your MySQL? If it's 5.7 or later, maybe same as this question:

    Unsuccessfully granting privileges