Remove user completely from MySQL

mysql> delete from user where user = uname and host = hostname;

mysql> flush privileges;

or you could use:

mysql> DROP USER <username>;

mysql> flush privileges;