我自己是用第一行成功的其他會出現錯誤，在password附近，其他也紀錄說不定是我哪個地方沒有用好而已。
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
UPDATE user SET authentication_string=password('new_password') WHERE user='root';
延伸閱讀： 登入 MySQL localhost 錯誤 Source: ERROR 1064 (42000): You have an error in your SQL syntax; Want to configure a password as root being the user
