mysql5.7.x用壓縮包安裝

MySQL5.7.33安裝教程_mysql 5.7.33-CSDN部落格

安裝完會生成 使用者root+隨機密碼，隨機密碼不能一直用，要重置後才能正常使用，文章裡的 3.10 ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; 會報錯“You must reset your password using ALTER USER statement before executing this statement.”

要換成 You must reset your password using ALTER USER statement before executing this statement.

alter user user() identified by "密碼";