MySQL 8+ 更改root用户密码_mysql8 set root password

查了网上的方法，有两种：

SET PASSWORD FOR 'root'@'localhost' = PASSWORD("your password");
1

和

update user set password=PASSWORD("your password") where User='root';
1

发现均在password函数附近报错

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...
1

查看文档后发现PASSWORD函数已经被删除（原文），新的方法是

ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'your passwd';
1

返回Query OK