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