今天 创建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;
结果如下: