:-: mysql跳过密码验证登录 --: 时间：2018.09.13 作者：Darren.liu * * * * * ### ***特别提示***：mysql不同安装办法目录不同，centos7通用查看软件状态 systemctl status mysqld systemctl restart mysqld ### 1.vim etc/my.cnf 添加 skip-grant-tables ### 2.重新启动mysqld /etc/init.d/mysqld restart ### 3.登录并修改MySQL的root密码 /usr/bin/mysql mysql USE mysql ; mysql> UPDATE user SET password = password('aszh2017MAGIC') WHERE User = 'root'; //注意别踩坑，下面已经给你写好了mysql5.7 root账号密码重置 update user set authentication_string = password('aszh2017MAGIC'), password_expired = 'N', password_last_changed = now() where user = 'root';mysql flush privileges ; ### 4.将MySQL的登录设置修改回来 vim etc/my.cnf 删除 skip-grant-tables ### 5.重新启动mysqld /etc/init.d/mysqld restart