mysql5.7忘记root密码以及授权远程访问解决方案

修改my.cnf配置文件# sudo vi /etc/my.cnf在[mysqld]的段中加上一句：skip-grant-tables,如下：[mysqld] datadir=/var/lib/mysql  socket=/var/lib/mysql/mysql.sock  skip-grant-tables 重启服务# sudo systemctl restart mysqld登陆并修改密码# mysql -uroot# mysql> use mysql修改密码MySQL 5.7.6 以及最新版本：# mysql> update user set authentication_string=PASSWORD('newpass') where User='root';MySQL 5.7.5 或更早之前的版本r:# mysql> update user set password=PASSWORD('newpass') where User='root';登陆测试将my.cnf的设置修改回来，重启MySQL服务，并登陆测试：# mysql -u root -p输入设置的密码，测试修改成功。授权远程访问1. mysql -u root -p  //先登录mysql2.GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'your_root_password' WITH GRANT OPTION;3.FLUSH PRIVILEGES;