赞
踩
mysql> create user 'huibang'@'%' identified by 'huibang@123';
ERROR 1396 (HY000): Operation CREATE USER failed for 'huibang'@'%'
mysql> drop user 'huibang'@'%';
Query OK, 0 rows affected (0.02 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> create user 'huibang'@'%' identified by 'huibang@123';
Query OK, 0 rows affected (0.00 sec)
网上找了下原因:
Assume the user is there, so drop the user
After deleting the user, there is need to flush the mysql privileges
Now create the user.
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。