刪除用戶

  1. 刪除用戶 dywang@localhost。
    MariaDB root@(none):mysql> drop user 'dywang'@'localhost';
    You're about to run a destructive command.
    Do you want to proceed? (y/n): y
    Your call!
    Query OK, 0 rows affected
    Time: 0.012s
    
  2. 查詢用戶 dywang,已不存在。
    MariaDB root@(none):(mysql)> select user from user;
    +-------------+
    | User        |
    +-------------+
    | mariadb.sys |
    | mysql       |
    | root        |
    +-------------+
    
    3 rows in set
    Time: 0.016s
    
  3. root 登出 mariadb。
    MariaDB root@(none):mysql> quit;
    Goodbye!