mysql 5.7授权所有数据库无效的问题
mysql> create user user01@'%' identified by 'abcdefgh';Query OK, 0 rows affected (0.04 sec)
mysql> grant all on *.* to user01@'%' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.06 sec)
mysql> show grants for user01@'%';
+------------------------------------+
| Grants for user01@% |
+------------------------------------+
| GRANT USAGE ON *.* TO 'user01'@'%' |
+------------------------------------+
1 row in set (0.00 sec)
centos 7.2
上述操作在5.6的数据库中没有问题。5.7中还要怎样设置呢？
页:
[1]