解决报错ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code

问题的由来
MySQL服务没有正常关机，是电脑没电后自动关机产生，记录一下排查过程
1.本以为是pid的问题，上网找了教程，解决不了，然后看日志
看了网上各种说是数据库内存溢出
2021-03-12T10:41:18.317167Z 0 [Note] Binlog end
2021-03-12T10:41:18.317217Z 0 [Note] Shutting down plugin 'CSV'
2021-03-12T10:41:18.317389Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2021-03-12T10:41:18.671273Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-03-12T10:41:18.672016Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.33-0ubuntu0.18.04.1) starting as process 2125 ...
2021-03-12T10:41:18.675569Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-03-12T10:41:18.675608Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-03-12T10:41:18.675611Z 0 [Note] InnoDB: Uses event mutexes
2021-03-12T10:41:18.675614Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-03-12T10:41:18.675617Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-03-12T10:41:18.675619Z 0 [Note] InnoDB: Using Linux native AIO
2021-03-12T10:41:18.675770Z 0 [Note] InnoDB: Number of pools: 1
2021-03-12T10:41:18.675820Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-03-12T10:41:18.677170Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-03-12T10:41:18.684020Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-03-12T10:41:18.685248Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-03-12T10:41:18.699329Z 0 [ERROR] InnoDB: Only one log file found.
2021-03-12T10:41:18.699360Z 0 [ERROR] InnoDB: Plugin initialization aborted with error not found
2021-03-12T10:41:19.310191Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-03-12T10:41:19.310270Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-03-12T10:41:19.310284Z 0 [ERROR] Failed to initialize builtin plugins.
2021-03-12T10:41:19.310290Z 0 [ERROR] Aborting

2021-03-12T10:41:19.310340Z 0 [Note] Binlog end
2021-03-12T10:41:19.310422Z 0 [Note] Shutting down plugin 'CSV'
2021-03-12T10:41:19.310978Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2.排查日志后发现，因为/var/lib/ib_logfile中记录者innoDB一些引擎的信息，在server未正常关闭的情况下，重启后的server不支持innodb的引擎，删除记录innodb的配置文件，

rm -rf ./ib_logfile*

重启mysql，启动正常
systemctl start mysqld
Failed to start mysqld.service: Unit mysqld.service not found.
root@mysql-master:/var/lib/mysql# systemctl start mysqld
Failed to start mysqld.service: Unit mysqld.service not found.
root@mysql-master:/var/lib/mysql# systemctl start mysql
root@mysql-master:/var/lib/mysql# systemctl status mysql
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Fri 2021-03-12 18:44:30 CST; 5s ago
  Process: 2199 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, 
  Process: 2175 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 2201 (mysqld)
    Tasks: 27 (limit: 2290)
   CGroup: /system.slice/mysql.service
           └─2201 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid

Mar 12 18:44:28 mysql-master systemd[1]: Starting MySQL Community Server...
Mar 12 18:44:30 mysql-master systemd[1]: Started MySQL Community Server.

查看MySQL的端口3306
ss -tnl
State       Recv-Q       Send-Q              Local Address:Port                Peer Address:Port       
LISTEN      0            128                       0.0.0.0:111                      0.0.0.0:*          
LISTEN      0            128                 127.0.0.53%lo:53                       0.0.0.0:*          
LISTEN      0            128                       0.0.0.0:22                       0.0.0.0:*          
LISTEN      0            128                     127.0.0.1:6010                     0.0.0.0:*          
LISTEN      0            128                       0.0.0.0:37211                    0.0.0.0:*          
LISTEN      0            64                        0.0.0.0:2049                     0.0.0.0:*          
LISTEN      0            128                       0.0.0.0:47459                    0.0.0.0:*          
LISTEN      0            64                        0.0.0.0:43461                    0.0.0.0:*          
LISTEN      0            128                       0.0.0.0:50475                    0.0.0.0:*          
LISTEN      0            64                           [::]:37039                       [::]:*          
LISTEN      0            128                          [::]:111                         [::]:*          
LISTEN      0            128                          [::]:22                          [::]:*          
LISTEN      0            128                          [::]:38455                       [::]:*          
LISTEN      0            128                         [::1]:6010                        [::]:*          
LISTEN      0            64                           [::]:2049                        [::]:*          
LISTEN      0            128                          [::]:52773                       [::]:*          
LISTEN      0            128                          [::]:37129                       [::]:*          
LISTEN      0            80                              *:3306                           *:*          



mysql的端口ok，正常访问数据库没有问题