MariaDB忘记root密码

停止mariadb#systemctl stop mariadb.service #vi /etc/my.cnf在[mysqld]中增加一行skip-grant-tables保存，然后启动mariadb#systemctl start mariadb.service 进入mariadb#mysql -uroot -p按回车进入>update mysql.user  set password=password('newpassword') where user='root';>quit;  #vi /etc/my.cnf将原来修改的语句注释掉#skip-grant-tables 重启mariadb即可#systemctl restart mariadb.service