update mysql.user set authentication_string=‘chen1019’ where user=“root”;
最开始在centos安装好了mysql,然后想修改密码,怎么也修改不了,还鼓捣了下配置文件啥的,然后不知怎么,mysqld服务都打不开了。。。。
查了好久emmmm,修改文件,还有修改swappon之类的,都无法解决:
错误如下
[root@localhost ~]# systemctl start mysqld
Job for mysqld.service failed because the control process exited with error code.
See “systemctl status mysqld.service” and “journalctl -xe” for details.
然后想了下,是不是有mysqld的僵尸进程,执行下面语句把mysqld进程杀死,:
pkill -9 mysqld
再重启服务,查看服务,成功:
systemctl start mysqld
systemctl status mysqld
然后我们再修改密码:
先进入mysql,我们查看密码强度ÿ