MySql5.7忘记root密码重置|开机启动|访问权限
修改密码
#mysqld_safe --skip-grant-tables --skip-networking &
#mysql -u root
MySql >update mysql.user set authentication_string=password('root123456') where user='root';
MySql >flush privileges;
MySql >quit;
修改用户访问权限
MySql >update user set host='%' where user = 'root';
添加开机启动
#cp mysql.server /etc/init.d/mysql
#chmod +x /etc/init.c/mysql
#chkconfig --add mysql