create user foo@localhost;
select user,host,password from mysql.user where user='foo';
User	Host	Password
foo	localhost	
select user,host,password,plugin,authentication_string from mysql.user where user='foo';
User	Host	Password	plugin	authentication_string
foo	localhost	*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29	mysql_native_password	*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29
drop user foo@localhost;