MySQL环境
解决方法:
1.修改配置文件
[root@localhost ~]# vim /etc/my.cnf
输入以下:
skip-grant-tables
2.重启服务
[root@localhost ~]# systemctl restart mysqld
3.进入sql重置密码
mysql> update mysql.user
-> set authentication_string=password('Sirius123!')
-> where (User, Host) = ('root','localhost);
Query OK, 1 row affected, 1 warning (0.18 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> flush privileges;
Query OK, 0 rows affected (0.12 sec)
mysql> \q
Bye
4.删除配置
[root@localhost ~]# vim /etc/my.cnf
找到skip-grant-tables,并删除
5.重启服务,以更新的密码进入sql
[root@localhost ~]# systemctl restart mysqld
[root@localhost ~]# mysql -uroot -p
Enter password:
此时成功进入sql界面。