重置mysql密码-Mariadb5.5

vim /etc/my.cnf

[mysql]

+skip-grant-tables

 

systemctl restart mariadb

 

进入mysql

use mysql 

update user set Password=password('password') where User='root'

flush privileges

退出mysql

 

vim /etc/my.cnf

[mysql]

#skip-grant-tables

systemctl restart mariadb