1create user foo@localhost;
2select user,host,password from mysql.user where user='foo';
3User	Host	Password
4foo	localhost
5select user,host,password,plugin,authentication_string from mysql.user where user='foo';
6User	Host	Password	plugin	authentication_string
7foo	localhost	*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29	mysql_native_password	*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29
8drop user foo@localhost;
9