mysql忘记密码修改方法
忘记密码的更该方法:
https://blog.csdn.net/huanghaifei922/article/details/54644818
1.vi /etc/my.cnf 这个可以用xftp改
2.在[mysqld]中添加
skip-grant-tables
例如:
[mysqld]
skip-grant-tables
datadir=/var/lib/mysql
3.重启mysql
service mysql restart
4.用户无密码登录 (直接点击回车,如果提示输入密码,再回车)
mysql -uroot -p
5.选择数据库(注意后面的分号要带上)
use mysql;
6.修改root密码
update user set authentication_string=password('123456') where user='root';
7.执行
flush privileges;
8.退出
exit;
9.删除
vi /etc/my.cnf
删除 skip-grant-tables
10.重启mysql
service mysql restart
下面这个没用
https://blog.csdn.net/heatdeath/article/details/79066191
2.在用mysqld_safe命令重置root用户密码时,提示command not found...
搜索发现这个,mysql 5.7 在centos 7 上,是用systemd管理的,相应操作如下:
UPDATE mysql.user SET authentication_string = PASSWORD('gao725224') WHERE User = 'root' AND Host = 'localhost';
\1. Stop mysql:
systemctl stop mysqld
\2. Set the mySQL environment option
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
\3. Start mysql usig the options you just set
systemctl start mysqld
\4. Login as root
mysql -u root