centos mysql 启动不了

2016-08-04 02:29:20 6.1k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

填坑解决Centos7 Docker启动不了Mysql 想在centos7上用docker启动一个mysql容器，一直启动不起来，什么配置都没改动，死活起不起来，用docker命令查看logs docker logs mysql 并没有报什么错，就是自己shutdown了，各种找办法尝试，都一样，卧槽，心累。后来，用docker search mysql发现有专门为centos适配的MySQL版本 docker search mysql 果断拉下来 docker pull centos/mysql-57-centos7 .. 阅读详情

今天显得没事，想改一下日志的路径，然后就。。。起不来了

max_allowed_packet = 20M

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock



# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0



# Recommended in standard MySQL setup

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES



[mysqld_safe]

log-error=/data/logs/mysql/mysqld.log

#log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid





#log=/data/logs/mysql/all.log



#log-output=FILE

#general-log=1

#general_log_file=/data/logs/mysql/general.log





#log-output=FILE

#slow_query_log=1

#slow_query_log_file=/data/logs/mysql/show.log

#long_query_time=10

怎么改都启动不了，改为原来的还是启动不了
启动了很长时间，提示

[root@iZ25mz6qyb8Z ~]# service mysqld restart 

Redirecting to /bin/systemctl restart  mysqld.service

Job for mysqld.service failed. See 'systemctl status mysqld.service' and 'journalctl -xn' for details.

然后按照提示执行

[root@iZ25mz6qyb8Z ~]# systemctl status mysqld.service

mysqld.service - MySQL Community Server

   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)

   Active: activating (start-post) since 四 2016-08-04 14:22:40 CST; 4min 26s ago

  Process: 13385 ExecStart=/usr/bin/mysqld_safe (code=exited, status=0/SUCCESS)

  Process: 13374 ExecStartPre=/usr/bin/mysql-systemd-start pre (code=exited, status=0/SUCCESS)

 Main PID: 13385 (code=exited, status=0/SUCCESS);         : 13386 (mysql-systemd-s)

   CGroup: /system.slice/mysqld.service

           `-control

             |-13386 /bin/bash /usr/bin/mysql-systemd-start post

             `-14383 sleep 1



8月 04 14:22:40 iZ25mz6qyb8Z systemd[1]: mysqld.service holdoff time over, scheduling restart.

8月 04 14:22:40 iZ25mz6qyb8Z systemd[1]: Stopping MySQL Community Server...

8月 04 14:22:40 iZ25mz6qyb8Z systemd[1]: Starting MySQL Community Server...

8月 04 14:22:40 iZ25mz6qyb8Z mysqld_safe[13385]: 160804 14:22:40 mysqld_safe Logging to '/data/logs/mysql/mysqld.log'.

8月 04 14:22:40 iZ25mz6qyb8Z mysqld_safe[13385]: 160804 14:22:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

8月 04 14:22:40 iZ25mz6qyb8Z mysqld_safe[13385]: 160804 14:22:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

[root@iZ25mz6qyb8Z ~]# journalctl -xn

-- Logs begin at 日 2016-07-24 17:40:39 CST, end at 四 2016-08-04 14:22:40 CST. --

8月 04 14:20:01 iZ25mz6qyb8Z CROND[12895]: (root) CMD (/usr/lib64/sa/sa1 1 1)

8月 04 14:22:40 iZ25mz6qyb8Z systemd[1]: mysqld.service operation timed out. Stopping.

8月 04 14:22:40 iZ25mz6qyb8Z systemd[1]: Failed to start MySQL Community 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.

8月 04 14:22:40 iZ25mz6qyb8Z systemd[1]: Unit mysqld.service entered failed state.

8月 04 14:22:40 iZ25mz6qyb8Z systemd[1]: mysqld.service holdoff time over, scheduling restart.

8月 04 14:22:40 iZ25mz6qyb8Z systemd[1]: Stopping MySQL Community Server...

-- Subject: Unit mysqld.service has begun shutting down

-- Defined-By: systemd

-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

-- 

-- Unit mysqld.service has begun shutting down.

8月 04 14:22:40 iZ25mz6qyb8Z systemd[1]: Starting MySQL Community Server...

-- Subject: Unit mysqld.service has begun with start-up

-- Defined-By: systemd

-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

-- 

-- Unit mysqld.service has begun starting up.

8月 04 14:22:40 iZ25mz6qyb8Z mysqld_safe[13385]: 160804 14:22:40 mysqld_safe Logging to '/data/logs/mysql/mysqld.log'.

8月 04 14:22:40 iZ25mz6qyb8Z mysqld_safe[13385]: 160804 14:22:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

8月 04 14:22:40 iZ25mz6qyb8Z mysqld_safe[13385]: 160804 14:22:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended