drop mysql user code example

Example 1: mysql deltete user

DROP USER 'jeffrey'@'localhost';

Example 2: mysql delete user if exists

DROP USER IF EXISTS 'user'@'127.0.0.1' ;

Example 3: mysql remove user privileges

REVOKE ALL PRIVILEGES ON database_name.* FROM 'username'@'host';
OR 
DROP USER 'username'@'host';