忘记密码,修改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;
忘记密码,修改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;