Linux系统MySQL重启失败(Can't create/write to file '/var/run/mysqld/mysqld.pid')

查看异常日志 `

vim /var/log/mysqld.log `
发现:

2021-04-08T06:09:36.130934Z 0 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 - No such file or directory)
2021-04-08T06:09:36.130972Z 0 [ERROR] Can't start server: can't create PID file: No such file or directory

经过查看发现mysqld文件夹不存在

处理方式

创建mysqld文件夹

    mkdir /var/run/mysqld

将 /var/run/mysqld/权限赋给mysql

    chown -R mysql /var/run/mysqld
    chgrp -R mysql /var/run/mysqld

启动MySQL

    service mysqld start