SELECT User, Host FROM mysql.user;

DROP USER 'username'@'host';