DROP USER

    1. DROP USER 'idontexist';
    1. ERROR 1396 (HY000): Operation DROP USER failed for idontexist@%
    1. DROP USER IF EXISTS 'idontexist';
    1. Query OK, 0 rows affected (0.01 sec)
    1. CREATE USER 'newuser' IDENTIFIED BY 'mypassword';
    1. GRANT ALL ON test.* TO 'newuser';
      1. +-------------------------------------------------+
      2. | Grants for newuser@%                            |
      3. +-------------------------------------------------+
      4. | GRANT USAGE ON *.* TO 'newuser'@'%'             |
      5. | GRANT ALL PRIVILEGES ON test.* TO 'newuser'@'%' |
      6. +-------------------------------------------------+
      7. 2 rows in set (0.00 sec)
      1. REVOKE ALL ON test.* FROM 'newuser';
      1. +-------------------------------------+
      2. | Grants for newuser@%                |
      3. | GRANT USAGE ON *.* TO 'newuser'@'%' |
      4. +-------------------------------------+
      5. 1 row in set (0.00 sec)
      1. DROP USER 'newuser';
      1. Query OK, 0 rows affected (0.14 sec)
      1. SHOW GRANTS FOR 'newuser';
      • 在 TiDB 中删除不存在的用户时，使用 可避免出现警告。