You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio

今天 创建mysql用户的时候报错

报错如下：

 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 'indentified by  'hybris'' at line 1

 

原因：

第一行有语法错误，那么需要检查创建mysql语句是否错误。

 

解决方法：

mysql创建密码的命令拼写错误，应该是如下：

CREATE USER '用户名' IDENTIFIED BY '密码';  

上代码：

CREATE USER 'kfcx' IDENTIFIED BY 'kfcx123';  
CREATE USER 'hybris' IDENTIFIED BY 'hybris';  

重新执行，成功创建用户

查询数据库中的用户命令：

 select user,host from mysql.user;

查看所有用户

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

结果如下：