MYSQL创建数据库报错 “ERROR 1396 (HY000): Operation CREATE USER failed for 'wordpress'@'10.0.0.%'”
MYSQL创建数据库报错 “ERROR 1396 (HY000): Operation CREATE USER failed for 'wordpress'@'10.0.0.%'”
因为之前创建过用户，并删除WordPress用户，所以刷新一下
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> create user wordpress@'10.0.0.%' identified by '123456';
ERROR 1396 (HY000): Operation CREATE USER failed for 'wordpress'@'10.0.0.%'
mysql> select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)
但还是相同报错，再次执行删除用户命令，成功创建
mysql> drop user 'wordpress'@'10.0.0.%';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| wordpress | 10.0.0.% |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+------------------+-----------+
5 rows in set (0.01 sec)
