mysql8改密码
登录后执行语句
ALTER USER 'test'@'localhost' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY '新密码';
修改Host范围
update user set host = "%" where user = "root";
mysql跳过权限认证
1、my.cnf增加如下配置
skip-grant-tables
2、使用mysql本地登陆
# sock文件所在位置从my.cnf查
mysql -S sock文件所在位置 -u root -p