撤銷權限

1. 用戶 root 登入 mariadb，使用 mysql 資料庫。

   [root@kvm3 ~]# mycli -uroot -p123123
   Connecting to socket /var/lib/mysql/mysql.sock, owned by user mysql
   MariaDB 10.11.11
   mycli 1.39.1
   Home: http://mycli.net
   Bug tracker: https://github.com/dbcli/mycli/issues
   Thanks to the contributor - jweiland.net
   MariaDB root@(none):(none)> use mysql;
   You are now connected to database "mysql" as user "root"
   Time: 0.001s
   MariaDB root@(none):mysql>
   

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

   MariaDB root@(none):mysql> revoke Shutdown on *.* from 'dywang'@localhost;
   Query OK, 0 rows affected
   Time: 0.008s
   

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

   MariaDB root@(none):mysql> select * from user where user='dywang'\G
   ***************************[ 1. row ]***************************
   Host                   | localhost
   User                   | dywang
   Password               | *FD571203974BA9AFE270FE62151AE967ECA5E0AA
   Select_priv            | N
   Insert_priv            | N
   Update_priv            | N
   Delete_priv            | N
   Create_priv            | N
   Drop_priv              | N
   Reload_priv            | N
   Shutdown_priv          | N
   Process_priv           | N
   File_priv              | N
   Grant_priv             | N
   References_priv        | N
   Index_priv             | N
   Alter_priv             | N
   Show_db_priv           | N
   Super_priv             | N
   Create_tmp_table_priv  | N
   Lock_tables_priv       | N
   Execute_priv           | N
   Repl_slave_priv        | N
   Repl_client_priv       | N
   Create_view_priv       | N
   Show_view_priv         | N
   Create_routine_priv    | N
   Alter_routine_priv     | N
   Create_user_priv       | N
   Event_priv             | N
   Trigger_priv           | N
   Create_tablespace_priv | N
   Delete_history_priv    | N
   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  | *FD571203974BA9AFE270FE62151AE967ECA5E0AA
   password_expired       | N
   is_role                | N
   default_role           |
   max_statement_time     | 0.000000
   
   1 row in set
   Time: 0.015s
   MariaDB root@(none):mysql>