MySQL: Delete a user
by admin on Jan.17, 2011, under Random()
Sometimes it is also necessary to remove a MySQL user from the database. This can be done by executing the following command with a user that has administrative privileges (such as root):
DROP USER 'jeffrey'@'localhost';
The above code removes the user jeffrey.