1.MySQL权限级别
(1)全局性管理权限
作用于整个MySQL实例级别
*.*代表所有数据库的权限
mysql> grant all on *.* to 'test'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> grant select, insert on *.* to 'test'@'%';
Query OK, 0 rows affected (0.00 sec)*.*代表(1)全局性管理权限
作用于整个MySQL实例级别
*.*代表所有数据库的权限
mysql> grant all on *.* to 'test'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> grant select, insert on *.* to 'test'@'%';
Query OK, 0 rows affected (0.00 sec)*.*代表