Board logo

标题: [求助] mysqld 无法自启动 请大神帮忙看看错误日志 [打印本页]

作者: sava110    时间: 2016-11-29 00:17     标题: mysqld 无法自启动 请大神帮忙看看错误日志

本帖最后由 sava110 于 2016-11-29 00:18 编辑

[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    时间: 2016-12-2 14:20

64位   centos 7.2   全新安装
作者: dmcountry    时间: 2016-12-10 19:20

看来是普遍问题,我也遇到了,哪位有解决方案?
作者: dmcountry    时间: 2016-12-10 19:53

本人找到了解决方案解决在系统重启后mysqld不随系统自动重启问题,如下:

编辑文件:
vi /etc/rc.d/rc.local
增加下面命令,保存
/etc/rc.d/init.d/mysqld start

然后添加该文件可执行权限:
chmod +x /etc/rc.d/rc.local


经过验证该方案可行。




欢迎光临 WDlinux官方论坛 (http://wdlinux.cn/bbs/) Powered by Discuz! 7.2