忘记密码,修改my.cnf

[mysqld]

 skip-grant-tables=1

 

重设密码

use mysql

UPDATE user SET Password = password ( '123456' ) WHERE User = 'root' ; 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

flush privileges; 

更多推荐