记一次修复mysq启动/usr/local/mysql/bin/mysqld: Can't create/write to file '/home/data/logs/mysql/mysqld.pid

重启系统后，mysql启动不了

[root@MyCloudServer ~]# systemctl start mysqld
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.                       service" and "journalctl -xe" for details.

这个报错不靠谱，进mysql日志查看；查看日志，清除n久之前的：

cat /dev/null > /home/data/logs/mysql/error.log

看错误，贴图

2018-04-11 16:36:53 26990 [Note] Server hostname (bind-address): '*'; port: 3306
2018-04-11 16:36:53 26990 [Note] IPv6 is available.
2018-04-11 16:36:53 26990 [Note]   - '::' resolves to '::';
2018-04-11 16:36:53 26990 [Note] Server socket created on IP: '::'.
2018-04-11 16:36:53 26990 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/home/data/logs/mysql/mysqld.pid' (Errcode: 13 - Permission denied)
2018-04-11 16:36:53 26990 [ERROR] Can't start server: can't create PID file: Permission denied
180411 16:36:53 mysqld_safe mysqld from pid file /home/data/logs/mysql/mysqld.pid ended

无法创建pid，慢日志不能用，多半是用户权限问题

chown mysql.mysql /home/data/logs/mysql

启动

systemctl start mysqld.service

ok