win10 修改 mysql80 密码

MySQL  localhost:33060+ ssl  mysql  SQL > select version();
+-----------+
| version() |
+-----------+
| 8.0.23    |
+-----------+
1 row in set (0.0004 sec)
 MySQL  localhost:33060+ ssl  mysql  SQL > set password for  root@localhost = password ('123');
ERROR: 1064: 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
 MySQL  localhost:33060+ ssl  mysql  SQL > alter user 'root'@'localhost' IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.0046 sec)
 MySQL  localhost:33060+ ssl  mysql  SQL >

• set password for root@localhost = password ('123');不行
• alter user 'root'@'localhost' IDENTIFIED BY 'root';可以