- 論壇徽章:
- 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的數(shù)據(jù)庫中沒有問題。5.7中還要怎樣設置呢? |
|