MySQL重置密码
1.打开my.cnf文件
#在[mysqld]的段中加入
skip-grant-tables
2.重启mysqld
service mysqld restart
3.输入
mysql -u root -p
#然后直接敲回车
4.修改密码(5.7之前)
use mysql
update user set password=password('new password') where user='root'
flush privileges
quit
修改密码(5.7之后)
use mysql
update user set authentication_string=password('新密码') where user='root'
flush privileges
quit
5.删除在my.cnf中加入的语句
6.重启mysqld