备注:mysql版本为5.7
关闭mysql服务
service mysql stop
# 或者直接杀死mysql相关进程
killall -9 mysqld
以不检查权限的方式启动mysql;
mysqld_safe --skip-grant-tables &
# 或者配置在my.cnf的mysqld下,然后重启mysql
[mysqld]
skip-grant-tables
然后用空密码方式使用root用户登录 MySQL;
mysql -u root
修改root用户的密码;
mysql> update mysql.user set authentication_string = password('root'), password_expired = 'N', password_last_changed = now() where User = 'root';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
停止mysql服务
service mysql.server stop
正常启动mysql
service mysql.server start
正常登陆mysql
mysql -uroot -proot