CentOS 7 安装 MySQL 无法启动,求指教

2016-05-09 23:06:16 +08:00
 Sparetire

以前一直用 Debian 系,照着官方文档一路装过来都没啥问题,最近想换口味装了个 CentOS 7 ,结果一个 MySQL 就搞了一晚上没搞定。。

大致过程,从官网下了个 Yum Repository

# rpm -ivh mysql57-community-release-el7-8.noarch.rpm
# yum update
# yum install mysql-community-server

一路顺利,然后启动

# 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.

报错,照着提示看了下发现并不能看懂。。对着一些信息搜索也无果,求教是什么原因

# systemctl status mysqld.service
  mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: failed (Result: start-limit) since Tue 2016-05-10 08:03:40 CST; 1min 11s ago
  Process: 5126 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  Process: 5104 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

May 10 08:03:40 FVCKGFW systemd[1]: Failed to start MySQL Server.
May 10 08:03:40 FVCKGFW systemd[1]: Unit mysqld.service entered failed state.
May 10 08:03:40 FVCKGFW systemd[1]: mysqld.service failed.
May 10 08:03:40 FVCKGFW systemd[1]: mysqld.service holdoff time over, scheduling restart.
May 10 08:03:40 FVCKGFW systemd[1]: start request repeated too quickly for mysqld.service
May 10 08:03:40 FVCKGFW systemd[1]: Failed to start MySQL Server.
May 10 08:03:40 FVCKGFW systemd[1]: Unit mysqld.service entered failed state.
May 10 08:03:40 FVCKGFW systemd[1]: mysqld.service failed.

# journalctl -xe
-- Subject: Unit mysqld.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has begun starting up.
May 10 08:03:40 FVCKGFW mysqld[5126]: Initialization of mysqld failed: 0
May 10 08:03:40 FVCKGFW systemd[1]: mysqld.service: control process exited, code=exited status=1
May 10 08:03:40 FVCKGFW 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.
May 10 08:03:40 FVCKGFW systemd[1]: Unit mysqld.service entered failed state.
May 10 08:03:40 FVCKGFW systemd[1]: mysqld.service failed.
May 10 08:03:40 FVCKGFW systemd[1]: mysqld.service holdoff time over, scheduling restart.
May 10 08:03:40 FVCKGFW systemd[1]: start request repeated too quickly for mysqld.service
May 10 08:03:40 FVCKGFW 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.
May 10 08:03:40 FVCKGFW systemd[1]: Unit mysqld.service entered failed state.
May 10 08:03:40 FVCKGFW systemd[1]: mysqld.service failed.
630 次点击
所在节点    MySQL
10 条回复
doyel
2016-05-09 23:08:59 +08:00
配置文件呢。。。还是没指定配置文件启动的?
yangqi
2016-05-09 23:11:58 +08:00
看 mysql 自己的 error log
raysonx
2016-05-09 23:18:14 +08:00
其实我想知道为什么楼主不用自带的 MariaDB ,非要用 rpm 安装 MySQL
Sparetire
2016-05-09 23:23:11 +08:00
刚刚发完贴就找到答案。。 https://stackoverflow.com/questions/34113689/job-for-mysqld-service-failed-centos-7 ,还是自己坑了,结贴,感谢各位
Sparetire
2016-05-09 23:24:38 +08:00
@raysonx 没用过 MariaDB ,怕不熟又得折腾半天。。

@yangqi 看了日志,也找到原因了,感谢
Neveroldmilk
2016-05-10 10:45:49 +08:00
没配置好 mysql 就启动了吧。
xsseroot
2016-05-10 11:27:15 +08:00
重启
Cu635
2016-05-10 15:05:11 +08:00
@Sparetire
mariadb 和 mysql 几乎完全兼容。
hbprotoss
2016-07-13 21:10:48 +08:00
@Cu635 生产环境可差不得这个“几乎”
Cu635
2016-08-11 12:00:28 +08:00
@hbprotoss

你这么说,反而不够严谨。你的这句话所表达的含义和你说“生产环境差不得”所想的含义其实是矛盾的。

如果你非得说的话,应该说“有的生产环境可差不得这个‘几乎’”。


其实绝大部分生产环境是可以无缝兼容的,可以很轻松的从 mysql 迁移到 mariadb ,但是有的生产环境确实不行。这也是我上面回复当中“几乎”的来源。


另外,@Livid , hbprotoss 在 28 天前就回复我了,但是未读提醒在我发这个帖子的时候才出来。这是个 bug 还是啥?

这是一个专为移动设备优化的页面(即为了让你能够在 Google 搜索结果里秒开这个页面),如果你希望参与 V2EX 社区的讨论,你可以继续到 V2EX 上打开本讨论主题的完整版本。

https://www.v2ex.com/t/277477

V2EX 是创意工作者们的社区,是一个分享自己正在做的有趣事物、交流想法,可以遇见新朋友甚至新机会的地方。

V2EX is a community of developers, designers and creative people.

© 2021 V2EX