3.MySql8.0修改root密码

MySql8.0修改root密码：

ALTER user ‘root’@‘localhost’ IDENTIFIED BY ‘newpassword’;

MySQL5.7修改root 密码：

首先登录MySQL。
格式：mysql> set password for 用户名@localhost = password(‘新密码’);
例子：mysql> set password for root@localhost = password(‘123’);