ERROR 1396 (HY000): Operation DROP USER failed for 'user'@'localhost'
	
DROP USER 'user'@'localhost';
	
select user,host
from mysql.user
where user = '<your-user>';
	
flush privileges;

drop user 'user'@'localhost';
	
delete from mysql.user
where user='<your-user>'
and host = 'localhost';

flush privileges;
	
CREATE USER 'user'@'%' IDENTIFIED BY 'passwd';
	
drop user 'user'@'localhost';
	
drop user 'user'@'%';