UPDATE user SET password=PASSWORD('new_password') WHERE user='root';

alter user 'root'@'localhost' identified by 'newPassword'; 
執行刷新權限，將上面的查詢提交到系統中
flush privileges;

set password for 'root'@'localhost'=password('123456');