MySQL权限控制

| Host | User      | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | 
Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | 
Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | 
Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | 
Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | 
x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin                | 
authentication_string                     | password_expired | password_last_changed | password_lifetime | 
account_locked |
1.
2.
3.
4.
5.
6.
7.
8.

```
mysql> show grants for 'test_user'@'%';
+---------------------------------------+
| Grants for test_user@%                |
+---------------------------------------+
| GRANT USAGE ON *.* TO 'test_user'@'%' |
+---------------------------------------+
1 row in set (0.00 sec)
```
1.
2.
3.
4.
5.
6.
7.
8.
9.

mysql> GRANT SELECT,UPDATE,DELETE,INSERT ON *.* TO 'test_user'@'%';
Query OK, 0 rows affected (0.01 sec)
1.
2.

mysql> GRANT ALTER ON easy_web.* TO 'test_user'@'%';
Query OK, 0 rows affected (0.00 sec)
1.
2.

mysql> GRANT INDEX ON easy_web.t_user TO 'test_user'@'%';
Query OK, 0 rows affected (0.00 sec)
1.
2.

mysql> GRANT SELECT(id,name) ON easy_web.t_user TO 'test_user'@'%';
Query OK, 0 rows affected (0.00 sec)
1.
2.

mysql> GRANT ALL ON easy_web.* TO 'test_user'@'%';
Query OK, 0 rows affected (0.00 sec)
1.
2.

mysql> REVOKE ALL ON easy_web.* FROM 'test_user'@'%';
Query OK, 0 rows affected (0.00 sec)
1.
2.

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
1.
2.

mysql> DROP USER 'test_user'@'%';
Query OK, 0 rows affected (0.01 sec)
1.
2.