当前位置:论坛首页 > Linux面板 > 求助

MySQL启动不了怎么办

发表在 Linux面板2017-7-25 16:42 [复制链接] 1 2041

启动了没用,还是停止状态
下面是错误日志
170725  9:44:53 [Note] Plugin 'FEDERATED' is disabled.
170725  9:44:53 InnoDB: The InnoDB memory heap is disabled
170725  9:44:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170725  9:44:53 InnoDB: Compressed tables use zlib 1.2.3
170725  9:44:53 InnoDB: Using Linux native AIO
/www/server/mysql/bin/mysqld: Can't create/write to file '/tmp/iblMoNyR' (Errcode: 13)
170725  9:44:53  InnoDB: Error: unable to create temporary file; errno: 13
170725  9:44:53 [ERROR] Plugin 'InnoDB' init function returned error.
170725  9:44:53 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170725  9:44:53 [ERROR] Unknown/unsupported storage engine: InnoDB
170725  9:44:53 [ERROR] Aborting

170725  9:44:53 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

170725  9:44:54 [Note] Plugin 'FEDERATED' is disabled.
170725  9:44:54 InnoDB: The InnoDB memory heap is disabled
170725  9:44:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170725  9:44:54 InnoDB: Compressed tables use zlib 1.2.3
170725  9:44:54 InnoDB: Using Linux native AIO
/www/server/mysql/bin/mysqld: Can't create/write to file '/tmp/ibZJzPg2' (Errcode: 13)
170725  9:44:54  InnoDB: Error: unable to create temporary file; errno: 13
170725  9:44:54 [ERROR] Plugin 'InnoDB' init function returned error.
170725  9:44:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170725  9:44:54 [ERROR] Unknown/unsupported storage engine: InnoDB
170725  9:44:54 [ERROR] Aborting

170725  9:44:54 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

170725  9:44:55 [Note] Plugin 'FEDERATED' is disabled.
170725  9:44:55 InnoDB: The InnoDB memory heap is disabled
170725  9:44:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170725  9:44:55 InnoDB: Compressed tables use zlib 1.2.3
170725  9:44:55 InnoDB: Using Linux native AIO
/www/server/mysql/bin/mysqld: Can't create/write to file '/tmp/ibIZjG38' (Errcode: 13)
170725  9:44:55  InnoDB: Error: unable to create temporary file; errno: 13
170725  9:44:55 [ERROR] Plugin 'InnoDB' init function returned error.
170725  9:44:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170725  9:44:55 [ERROR] Unknown/unsupported storage engine: InnoDB
170725  9:44:55 [ERROR] Aborting

170725  9:44:55 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

170725  9:45:03 [Note] Plugin 'FEDERATED' is disabled.
170725  9:45:03 InnoDB: The InnoDB memory heap is disabled
170725  9:45:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170725  9:45:03 InnoDB: Compressed tables use zlib 1.2.3
170725  9:45:03 InnoDB: Using Linux native AIO
/www/server/mysql/bin/mysqld: Can't create/write to file '/tmp/ibky9Xmw' (Errcode: 13)
170725  9:45:03  InnoDB: Error: unable to create temporary file; errno: 13
170725  9:45:03 [ERROR] Plugin 'InnoDB' init function returned error.
170725  9:45:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170725  9:45:03 [ERROR] Unknown/unsupported storage engine: InnoDB
170725  9:45:03 [ERROR] Aborting

170725  9:45:03 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

170725 16:25:55 [Note] Plugin 'FEDERATED' is disabled.
170725 16:25:55 InnoDB: The InnoDB memory heap is disabled
170725 16:25:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170725 16:25:55 InnoDB: Compressed tables use zlib 1.2.3
170725 16:25:55 InnoDB: Using Linux native AIO
/www/server/mysql/bin/mysqld: Can't create/write to file '/tmp/ib0PrFRb' (Errcode: 13)
170725 16:25:55  InnoDB: Error: unable to create temporary file; errno: 13
170725 16:25:55 [ERROR] Plugin 'InnoDB' init function returned error.
170725 16:25:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170725 16:25:55 [ERROR] Unknown/unsupported storage engine: InnoDB
170725 16:25:55 [ERROR] Aborting

170725 16:25:55 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

1111111.png
使用道具 举报 只看该作者 回复
发表于 2017-7-26 14:19:54 | 显示全部楼层
应该是innodb日志文件有问题,或者你改过innodb配置导致:
rm -f /www/server/data/ib_logfile*
使用道具 举报 回复 支持 反对
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

普通问题处理

论坛响应时间:72小时

问题处理方式:排队(仅解答)

工作时间:白班:9:00 - 18:00

紧急运维服务

响应时间:3分钟

问题处理方式:宝塔专家1对1服务

工作时间:工作日:9:00 - 18:30

宝塔专业团队为您解决服务器疑难问题

点击联系技术免费分析

工作时间:09:00至18:30

快速回复 返回顶部 返回列表