create user foo@localhost;
select user,host,password from mysql.user where user='foo';
user	host	password
foo	localhost	
select user,host,password from mysql.user where user='foo';
user	host	password
foo	localhost	*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29
drop user foo@localhost;