centos7中mysql5.7启动失败
我今天在使用Python插入数据库时,首先是莫名其妙数据库断开连接,然后再重启,就死活启动不了,
Job for mysqld.service failed because the control process exited with error code. See “systemctl status mysqld.service” and “journalctl -xe” for details.
并且最坑的是,无论是
systemctl status mysqld.service
service mysqld status
journalctl -xe
/var/log/mysqld.log
里面没有任何一个带err或者error的,让人完全没有任何办法,
照着网上的各种配置各种重装了1天,然后晚上的时候碰运气解决了。
如果你的mysql启动失败并且照着网上那些修改配置文件等不起作用,并且不论是看/var/log/mysqld.log还是systemctl status mysqld.service
service mysqld status都没有任何错误提示的情况下,可是试试下面的办法去碰运气
先删除MySQL
查看
rpm -qa |grep -i mysql
删除
yum remove mysql-community-common-5.7.31-1.el7.x86_64
yum remove mysql57-community-release-el7-10.noarch
yum remove mysql-community-libs-5.7.31-1.el7.x86_64
yum remove mysql-community-server-5.7.31-1.el7.x86_64
yum remove mysql-community-client-5.7.31-1.el7