18.04 set mysql password

[yehlu]

mysql> use mysql

UPDATE user SET plugin='mysql_native_password' WHERE User='root';
UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE USER='root';
FLUSH PRIVILEGES;