18.04 set mysql password
發表於 : 2019-05-13 16:31:58
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;
CodeCharge Studio, DemoCharge, SuperPDF
https://bug.551.com.tw/
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;