Mysql DROP USER

MySQL DROP USER Function

This function removes MySQL accounts and their privileges.

Syntax DROP USER

• username is the user to remove
• hostname is the user host name.

DROP USER username@hostname;

Example 1

mysql> DROP USER 'bob'@'toyoma-PC';
Query OK, 0 rows affected (0.00 sec)

Example 2

mysql> DROP USER 'joby'@'10.8.4.21';
Query OK, 0 rows affected (0.00 sec)

Related Links

• MySQL Account Management Statements
• MysQL Tutorial
• Tutorial Home

---

---CREATE USER--- DROP USER--- GRANT User Privilege--- RENAME USER--- REVOKE--- SET PASSWORD---

---