ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'%'

解决

1 mysql> drop user 'root'@'%';
2 Query OK, 0 rows affected (0.01 sec)
3 
4 mysql> flush privileges;
5 Query OK, 0 rows affected (0.00 sec)

此时重新创建就成功了！

posted @ 2022-04-18 20:41  战神盖亚  阅读(2065)  评论(0)    收藏  举报