mariadb忘记root密码
如果您忘记了MariaDB的root密码,可以按照以下步骤来重置密码:
停止MariaDB服务:
sudo systemctl stop mariadb
启动无权限表的MariaDB服务:
sudo mysqld_safe --skip-grant-tables &
登录到MariaDB:
mysql -u root
在MariaDB命令行中,用以下命令刷新权限表:
FLUSH PRIVILEGES;
设置新的root密码:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');
或者对于MariaDB 10.4及以上版本,使用:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
退出MariaDB命令行:
EXIT;
关闭无权限表的MariaDB服务:
[root@centos7 ~]# ss -lntup | grep 3306
tcp LISTEN 0 50 *:3306 *:* users:(("mysqld",pid=1647,fd=14))
[root@centos7 ~]# kill -TERM 1647
[root@centos7 ~]# mysql -uroot -pnew_password
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.56-MariaDB MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
重新启动MariaDB服务:
sudo systemctl start mariadb