撤銷權限

1. revoke 撤銷用戶 dywang@localhost 的 shutdown 權限。

   MariaDB root@(none):mysql> revoke Shutdown on *.* from 'dywang'@localhost;
   

2. 查看用戶 dywang，shutdown_priv 變成 N。

   MariaDB root@(none):mysql> select * from user where user='dywang'\G
   ***************************[ 1. row ]***************************
   Host                   | localhost
   User                   | dywang
   Password               | *050376F3855A67F5E2C6514FD3130B31006C1276
   Select_priv            | Y
   Insert_priv            | Y
   Update_priv            | Y
   Delete_priv            | Y
   Create_priv            | Y
   Drop_priv              | Y
   Reload_priv            | Y
   Shutdown_priv          | N
   Process_priv           | Y
   File_priv              | Y
   Grant_priv             | N
   References_priv        | Y
   Index_priv             | Y
   Alter_priv             | Y
   Show_db_priv           | Y
   Super_priv             | Y
   Create_tmp_table_priv  | Y
   Lock_tables_priv       | Y
   Execute_priv           | Y
   Repl_slave_priv        | Y
   Repl_client_priv       | Y
   Create_view_priv       | Y
   Show_view_priv         | Y
   Create_routine_priv    | Y
   Alter_routine_priv     | Y
   Create_user_priv       | Y
   Event_priv             | Y
   Trigger_priv           | Y
   Create_tablespace_priv | Y
   Delete_history_priv    | Y
   ssl_type               |
   ssl_cipher             |
   x509_issuer            |
   x509_subject           |
   max_questions          | 0
   max_updates            | 0
   max_connections        | 0
   max_user_connections   | 0
   plugin                 | mysql_native_password
   authentication_string  | *050376F3855A67F5E2C6514FD3130B31006C1276
   password_expired       | N
   is_role                | N
   default_role           |
   max_statement_time     | 0.000000
   
   1 row in set
   Time: 0.052s