mysql8.0修改用户密码

• 方式一（刚安装的数据库只能使用此）

alter user user() identified BY '123456';
1

• 方式二

alter user user() identified BY '123456';
alter user `root` identified by '123456';
-- 或
alter user `root`@`%` identified by '123456';
1
2
3
4