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