[求助] mysqld 無法自啟動 請大神幫忙看看錯誤日志

sava110

[root@AY1407191035570016dbZ ~]# service mysqld restart
MySQL server PID file could not be found!                  [FAILED]
Starting MySQL..                                                     [  OK  ]







161129 00:04:23 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.49/data/AY1407191035570016dbZ.pid ended
161129 00:08:38 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.5.49/data
161129  0:08:39 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
161129  0:08:39 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
161129  0:08:39 [Note] /www/wdlinux/mysql-5.5.49/bin/mysqld (mysqld 5.5.49) starting as process 1644 ...
161129  0:08:39 [Note] Plugin 'FEDERATED' is disabled.
161129  0:08:39 InnoDB: The InnoDB memory heap is disabled
161129  0:08:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161129  0:08:39 InnoDB: Compressed tables use zlib 1.2.7
161129  0:08:39 InnoDB: Initializing buffer pool, size = 128.0M
161129  0:08:39 InnoDB: Completed initialization of buffer pool
161129  0:08:39 InnoDB: highest supported file format is Barracuda.
161129  0:08:39  InnoDB: Waiting for the background threads to start
161129  0:08:40 InnoDB: 5.5.49 started; log sequence number 1595675
161129  0:08:40 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
161129  0:08:40 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
161129  0:08:40 [Note] Server socket created on IP: '0.0.0.0'.
161129  0:08:40 [Note] Event Scheduler: Loaded 0 events
161129  0:08:40 [Note] /www/wdlinux/mysql-5.5.49/bin/mysqld: ready for connections.
Version: '5.5.49'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

sava110

64位   centos 7.2   全新安裝

dmcountry

看來是普遍問題，我也遇到了，哪位有解決方案？

dmcountry

本人找到了解決方案解決在系統(tǒng)重啟后mysqld不隨系統(tǒng)自動重啟問題，如下：

編輯文件：
vi /etc/rc.d/rc.local
增加下面命令，保存
/etc/rc.d/init.d/mysqld start

然后添加該文件可執(zhí)行權(quán)限：
chmod +x /etc/rc.d/rc.local


經(jīng)過驗證該方案可行。