今天下載了mysql（版本:mysql-8.0.12-winx64）來使用，在修改root密碼時(shí)總是提示語法錯(cuò)誤，很是郁悶，看了一遍又一遍還是沒找出毛病

問題：

mysql> set password for root@localhost = password('123');

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'password('123')' at line 1

解決方法：

使用如下語句即可解決

alter user 'root'@'localhost' identified by '123';