Linux下MySQL(Mariadb)忘记密码解决方案
mariadb安装
yum -y install mariadb mariadb-server
问题一:忘记密码情况
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
修改/etc/my.cnf配置文件
vim /etc/my.cnf
#在[mysqld]下增加以下内容来跳过登录时的密码保存并推出
skip-grant-tables
重启服务
#mysql重启
service mysqld restsrt
#mariadb重启
service mariadb restart
初始化数据库(下面也可以重设密码):
mysql_secure_installation
#回车后会有一下选项
1.Enter current password for root (enter for none):
#回车即可跳过
2.Set root password? [Y/n] y
#设置root密码
3.Remove anonymous users? [Y/n]
#删除匿名用户
4.Disallow root login remotely? [Y/n]
#禁止远程root登录
5.Remove test database and access to it? [Y/n]
#删除测试数据库并访问它
6.Reload privilege tables now? [Y/n]
#立即重新加载权限表
可以重设密码
mysql -uroot -p
#回车即可进入
use mysql;
update user SET Password = password('<Your Password>') where user='root';
flush privileges;