树莓派 ubuntu系统 ： mysql.service: Failed with result ‘exit-code‘

最近在做火灾报警系统的时候，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服务状态错误