[root@lizhan log]# service mysqld start Starting MySQL.The server quit without updating PID file (/[FAILED]mysqld/mysqld.pid).

查看日志位置（知道mysqld.log的位置的同学可以跳过）

[root@lizhan log]# whereis my.cnf #查找mysql配置文件 [root@lizhan log]# vim /etc/my.cnf #查看mysql配置文件

image.png
找到log-error和pid-file这两个参数，前者记录mysql日志位置，后者记录mysql的pid的位置

查看日志

[root@lizhan log]# vim /var/log/mysqld.log #查看日志 然后跳到文本的最后一行：按“G”,即“shift+g”

2020-02-19T05:59:45.713160Z 0 [Note] Server hostname (bind-address): ‘*’; port: 3306
2020-02-19T05:59:45.713217Z 0 [Note] IPv6 is available.
2020-02-19T05:59:45.713238Z 0 [Note] - ‘::’ resolves to ‘::’;
2020-02-19T05:59:45.713264Z 0 [Note] Server socket created on IP: ‘::’.
2020-02-19T05:59:45.716430Z 0 [ERROR] /usr/local/mysql/bin/mysqld: Can’t create/write to file ‘/var/run/mysqld/mysqld.pid’ (Errcode: 13 - Permission denied)
2020-02-19T05:59:45.716448Z 0 [ERROR] Can’t start server: can’t create PID file: Permission denied

解决办法

修改 /var/run/mysqld/权限为mysql
chown -R mysql /var/run/mysqld
chgrp -R mysql /var/run/mysqld