Mysql创建用户时执行 create user ‘root’@’%’ identified by ‘Zhonghui@123
出现如下错误:
ERROR 1396 (HY000): Operation CREATE USER failed for ‘root’@’%’
mysql> create user 'root'@'%' identified by 'Xielei@123'; ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'%'
原因分析:
1.已经存在了root用户
2.在执行删除root用户的时候没有删除干净
解决方法:
重新进行删除。
mysql> drop user root@'%';
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)