mysql remove user privileges code example

Example 1: mysql deltete user

DROP USER 'jeffrey'@'localhost';

Example 2: revokeprivileges mysql

REVOKE ALL ON dbname.* FROM 'username'@'localhost';

Example 3: mysql delete user if exists

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

Example 4: mysql remove user privileges

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

Example 5: how to delete user in mysql

DROP USER 'jeffrey'@'localhost';

FOR DELETING USER