mysql 启动问题，The server quit without updating PID file (/var/run/mysqld/mysqld.pid)

Starting MySQL. ERROR! The server quit without updating PID file (/var/run/mysqld/mysqld.pid)

首先描述下遇到的问题

[root@nodes mysql]# systemctl status mysqld.service
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: failed (Result: exit-code) since Sat 2020-07-25 10:41:53 CST; 11s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 16358 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=1/FAILURE)

Jul 25 10:41:52 nodes systemd[1]: Starting LSB: start and stop MySQL...
Jul 25 10:41:53 nodes mysqld[16358]: Starting MySQL. ERROR! The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
Jul 25 10:41:53 nodes systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 25 10:41:53 nodes  systemd[1]: Failed to start LSB: start and stop MySQL.
Jul 25 10:41:53 nodes systemd[1]: Unit mysqld.service entered failed state.
Jul 25 10:41:53 nodes systemd[1]: mysqld.service failed.

重启linux系统之后 mysql 需要手动启动,

执行命令: service mysqld start

执行后就报错了:Starting MySQL. ERROR! The server quit without updating PID file (/var/run/mysqld/mysqld.pid).

解决方案:
在/var/run/mysqld/目录下 创建mysqld.pid 文件

1.cd /var/run/mysqld/

2.touch mysqld.pid

3.chmod -R 777 /var/run/mysqld/ (给mysqld文件夹以及下面的子文件或者文件夹赋予 读写可执行权限)

4.service mysqld start

执行后成功

Starting MySQL. SUCCESS!