MariaDB忘记root密码

最新推荐文章于 2023-03-13 19:08:59 发布

镜花水月-李

最新推荐文章于 2023-03-13 19:08:59 发布

阅读量1.8k

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/weixin_42988176/article/details/124042463

版权

MariaDB忘记root密码

在mariadb的配置文件中加入下列一行

vim /etc/my.cnf.d/server.cnf

加入：

skip-grant-tables

重启mariadb服务

systemctl start mariadb.service

登录mysql

[root@vps]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.3.21-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [mysql]> use mysql
MariaDB [mysql]> update user set password=password('123456') where User='root';
Query OK, 4 rows affected (0.001 sec)
Rows matched: 5  Changed: 4  Warnings: 0

MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.000 sec)

MariaDB [mysql]> exit
Bye

还原配置文件
重启服务再次登录