最近在做火灾报警系统的时候,mysql服务老是会出现 mysql.service: Failed with result ‘exit-code’
这个错误,导致数据库运行不起来。
我的解决办法是:先kill mysqld有关的进程,再启动mysql服务,mysql就起来了。
查询mysqld进程
wzy@wzy-desktop$ ps -e | grep mysqld
63525 pts/0 00:00:03 mysqld
63760 ? 00:00:00 mysqld
结束进程
sudo kill -9 63525
sudo kill -9 63760
启动mysql服务:
wzy@wzy-desktop: service mysql start
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to start 'mysql.service'.
Authenticating as: wzy,,, (wzy)
Password:
==== AUTHENTICATION COMPLETE ===
查看mysql服务状态,就可以看到服务已经runing状态了。
wzy@wzy-desktop$ systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2022-04-18 13:37:47 CST; 29s ago
Process: 64891 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 64899 (mysqld)
Status: "Server is operational"
Tasks: 37 (limit: 4073)
Memory: 379.7M
CPU: 2.009s
CGroup: /system.slice/mysql.service
└─64899 /usr/sbin/mysqld
Apr 18 13:37:45 wzy-desktop systemd[1]: Starting MySQL Community Server...
Apr 18 13:37:47 wzy-desktop systemd[1]: Started MySQL Community Server.
到这里,我的连接就正常了,但是还不知道是什么原因导致的mysql服务状态错误