- 停止mysqld 进程:
systemctl stop mysqld
- 修改mysqld 运行环境参数,跳过密码输入环节:
systemctl set-environment MYSQLD_OPTS=“–skip-grant-tables”
- 启动mtsqld 进程:
systemctl start mysqld
- root 免密登录:
mysql -u root
- 重置密码:
方式一、
mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword') WHERE User = 'root' AND Host = 'localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit
方式二、
mysql> use mysql;
mysql> update user set host ='localhost' where user = 'root';
mysql> flush privileges;
mysql> exit
- 停止mysqld进程:
systemctl stop mysqld
- 取消mysqld免密登录相关参数:
systemctl unset-environment MYSQLD_OPTS
- 启动mysqld进程:
systemctl start mysqld
- 尝试用新设置的密码登录:
mysql -u root -p