centos7忘记mysql的密码
centos7忘记mysql的密码
方法一. 找回安装是的初始密码:
grep 'temporary password' /var/log/mysqld.log
方法二. 使用操作系统账号和密码,进行修改密码
mysql -uroot -p
输入你的centos的密码
ALTER user 'root'@'localhost' IDENTIFIED BY '新密码';
注:如果显示 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements,说明你的密码不符合安全要求,
FLUSH PRIVILEGES;
quit;
方法三. 强制进行修改密码
systemctl stop mysqld
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
systemctl start mysqld
mysql -u root
进入 mysql
ALTER user 'root'@'localhost' IDENTIFIED BY '新密码';
注:如果显示ERROR 1819 (HY000): Your password does not satisfy the current policy requirements,说明你的密码不符合安全要求,
FLUSH PRIVILEGES;
quit;
systemctl stop mysqld
systemctl set-environment MYSQLD_OPTS=""
systemctl start mysqld
参考
Last updated
Was this helpful?