- 论坛徽章:
- 0
|
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中还要怎样设置呢? |
|