mysqld 无法自启动 请大神帮忙看看错误日志
[i=s] 本帖最后由 sava110 于 2016-11-29 00:18 编辑 [/i][root@AY1407191035570016dbZ ~]# service mysqld restart
MySQL server PID file could not be found! [[color=#ff0000]FAILED[/color]]
Starting MySQL.. [ [color=#2e8b57]OK[/color] ]
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 64位 centos 7.2 全新安装 看来是普遍问题,我也遇到了,哪位有解决方案? 本人找到了解决方案解决在系统重启后mysqld不随系统自动重启问题,如下:
编辑文件:
vi /etc/rc.d/rc.local
增加下面命令,保存
/etc/rc.d/init.d/mysqld start
然后添加该文件可执行权限:
chmod +x /etc/rc.d/rc.local
经过验证该方案可行。
页:
[1]