How do you delete a user account from a database?

$1.$

DELETE USER username;

$2.$

DELETE USER username IDENTIFIED BY password;

$3.$

DROP USER username IDENTIFIED BY password;

$4.$

DROP USER username;