1、其它用户登录MySQL
2、
#查看user表
use mysql;
select user,plugin from user;
3、修改root密码格式
# 修改其密码格式
update user set plugin='mysql_native_password' where user='root';
# 查询其用户
select user,plugin from user;
# 刷新权限
flush privileges;
4、增加root密码
# 修改root账号密码
alter user 'root'@'localhost' identified by 'root';
# 在次刷新权限
flush privileges;
# 退出登录
exit
- localhost Ubuntu Access denied MySQLlocalhost ubuntu access denied localhost password access denied 39 localhost access denied localhost方法access denied maxwell mysql access denied 39 password access denied status_access_denied permission localhost publickey denied access denied basic http access denied clone basic