Question

创建mysql用户时候报错：

创建mysql用户时候报错：
root@127.0.0.1 : (none) 05:59:59> create user 'zabbix'@'%' identified by '123456';
ERROR 1054 (42S22): Unknown column 'plugin' in 'mysql.user'
Error (Code 1054): Unknown column 'plugin' in 'mysql.user'
Error (Code 1396): Operation CREATE USER failed for 'zabbix'@'%'
root@127.0.0.1 : (none) 05:59:36> select user,host from mysql.user;
+------+--------------------+
| user | host |
+------+--------------------+
| root | 127.0.0.1 |
| | leadeon.leadeon.cn |
| root | leadeon.leadeon.cn |
| | localhost |
| root | localhost |
+------+--------------------+
5 rows in set (0.00 sec)

Answer 1

命令错了
您百度一下“mysql命令”