MySQL权限控制

1. 为用户添加所有数据库的所有权限

GRANT ALL PRIVILEGES ON *.* TO root@'%' WITH GRANT OPTION;

2. 添加一个指定的权限

GRANT SELECT ON *.* TO root@'%' WITH GRANT OPTION;

3. 权限回收

revoke drop on *.* from test@localhost;#回收drop权限