Linux忘记mysql密码解决办法

1
2
3
4
5

mysql初始密码忘记

mysql密码忘记

mysql重置密码

1

vim /etc/my.cf

1

[mysqld]

1

skip-grant-tables

1

 :wq

1

systemctl restart mysqld.service

1

mysql -uroot -p    #提示输入密码直接回车

1

update mysql.user set authentication_string=password('123456') where User="root" and Host="localhost";

1

flush privileges;

1

grant all on *.* to 'root'@'localhost' identified by '123456' with grant option;

1
2
3
4
5
6
7

vim /etc/my.cf

# 删除/注释
skip-grant-tables

# 保存退出
:wq

1

systemctl restart mysqld.service

1
2
3
4

mysql -uroot -p

# 输入密码
123456