重启系统后,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