目录
1.开启跳过权限验证
vi /etc/my.cnf
[mysqld]
skip-grant-tables
/etc/init.d/mysqld restart
2.重置密码
use mysql;
update user set authentication_string=password(‘123456‘) where user=‘root‘ and host=‘localhost‘;
flush privileges;
/etc/init.d/mysqld restart
vi /etc/my.cnf
[mysqld]
skip-grant-tables #delete
/etc/init.d/mysqld restart
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘123456‘;