The command for deleting a user in MySQL is the same as deleting any other object, it is the DROP command
DROP USER mistycook@localhost