There are times when a database administrator or developer needs to remove a user from an application to ensure compliance, protect sensitive data, or for security reasons, such as when an employee has left a company. Removing a user from a database is easy with MySQL, which provides DB administrators with the DROP USER command for such cases.
The syntax of the DROP USER command in MySQL is pretty simple. To remove a user from a database in MySQL just use the following command:
DROP USERS