完美解决：ERROR 1064 (42000): You have an error in your SQL syntax； check the manual that corresponds to

目录

一、问题：

二、原因： 

三、解决方法：

四、拓展：

---

一、问题：

使用下列授权语句：

grant all privileges on mortal.* to 'xiaoqi'@'localhost' identified by 'mortalz7' with grant option;

【mortal：数据库名  xiaoqi：用户名  localhost：主机名   mortalz7：密码】 

遇到如下问题：

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 'mortalz7' with grant option' at line 1