:-: 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