Linux重置MySql密码(简洁版)

1. 关闭验证

   /etc/my.cnf-->[mysqld]-->skip-grant-tables

   
2. 重启MySql

   service mysql restart

3. 登陆MySql

   mysql -u root

4. 刷新权限

   FLUSH PRIVILEGES;

5. 更新密码

   ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

6. 退出MySql

   exit

7. 打开验证

   /etc/my.cnf-->[mysqld]-->skip-grant-tables

   
8. 重启MySql

   service mysql restart

9. 登陆MySql

   mysql -u root -p --> 123456