OS:Centos 7 Linux 3.10.0-229.el7.x86_64
MySQL: mysql57-community-release-el7-7.noarch.rpm
我通过安装MySQL服务器yum
。当我跑步时systemctl start mysqld
我收到以下错误
mysqld.service 作业失败。有关详细信息,请参阅“systemctl status mysqld.service”和“journalctl -xn”。
systemctl 状态 mysqld.service
MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
Active: failed (Result: start-limit) since Sun 2015-12-06 03:14:54 GMT;
4min 7s ago Process: 6992 ExecStart=/usr/sbin/mysqld
--daemonize $MYSQLD_OPTS (code=exited, status=1/FAILURE) Process: 6971 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited,
status=0/SUCCESS)
Dec 06 03:14:54 localhost.localdomain systemd[1]: mysqld.service: control process exited, code=exited status=1
Dec 06 03:14:54 localhost.localdomain systemd[1]: Failed to start MySQL Server.
Dec 06 03:14:54 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state.
Dec 06 03:14:54 localhost.localdomain systemd[1]: mysqld.service holdoff time over, scheduling restart.
Dec 06 03:14:54 localhost.localdomain systemd[1]: Stopping MySQL Server...
Dec 06 03:14:54 localhost.localdomain systemd[1]: Starting MySQL Server...
Dec 06 03:14:54 localhost.localdomain systemd[1]: mysqld.service start request repeated too quickly, refusing to start.
Dec 06 03:14:54 localhost.localdomain systemd[1]: Failed to start MySQL Server.
Dec 06 03:14:54 localhost.localdomain systemd[1]: Unit mysqld.service entered failed state. The journal command reads Failed to start MySQL Server
有什么想法我还应该看什么吗?
检查以下内容来解决问题
-
使用以下命令检查 mysql 数据目录的权限。所有权应该是mysql:mysql
并且目录权限应该是700
ls -ld /var/lib/mysql/
-
使用以下命令检查 mysql 数据目录内数据库的权限。该目录中所有文件的所有权应该是 mysql:mysql
ls -lh /var/lib/mysql/
-
使用以下命令检查侦听网络 tcp 端口
netstat -ntlp
-
使用以下命令检查 mysql 日志文件是否有任何错误。
cat /var/log/mysql/mysqld.log
-
尝试使用以下命令启动 mysql
mysqld_safe --defaults-file=/etc/my.cf
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)