本文共 1544 字,大约阅读时间需要 5 分钟。
centos7启动mysql报错
[root@bigdata01 ~]# systemctl start mysqldJob for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
查看信息后,没有任何有效信息,无法判断哪里出现问题,在网上查看很多方法,也无效很是头疼两天
[root@bigdata01 ~]# journalctl -xe-- -- The result is failed.Jun 06 07:46:34 bigdata01 systemd[1]: Unit mysqld.service entered faileJun 06 07:46:34 bigdata01 systemd[1]: mysqld.service failed.Jun 06 07:46:34 bigdata01 systemd[1]: mysqld.service holdoff time over,Jun 06 07:46:34 bigdata01 systemd[1]: start request repeated too quicklJun 06 07:46:34 bigdata01 systemd[1]: Failed to start MySQL Server.-- Subject: Unit mysqld.service has failed-- Defined-By: systemd-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel-- -- Unit mysqld.service has failed.-- -- The result is failed.Jun 06 07:46:34 bigdata01 systemd[1]: Unit mysqld.service entered faileJun 06 07:46:34 bigdata01 systemd[1]: mysqld.service failed.lines 3224-3239/3239 (END)
问题无法解决是因为不知道问题原因,后来,查找mysql错误日志,发现问题原因。
(1)mysql错误日志位置:
vi /etc/my.cnf
结果:
(2)确认这个日志是有写入权限的(自己竟然没有,结果启动mysql好几次,日志都是空白额)
(3)查看日志信息
vi error.log查看:...2019-06-05T23:58:51.416964Z 0 [Note] InnoDB: Using CPU crc32 instructionsmysqld: Can't create/write to file '/mysql_data/tmp/ibXafr1c' (Errcode: 13 - Permission denied)
(4)发现原因竟然是无法在目录下创建文件,晕
Can't create/write to file '/mysql_data/tmp/ibXafr1c'
赋予这个/mysql_data/tmp这个文件夹用户权限以及写入权限
chown -R mysql:mysql tmp/
以及
chmod 777 -R tmp/
然后重启mysql就ok
日志是根本,多看日志!
转载地址:http://xgygi.baihongyu.com/