Linux mysql服务器无法启动或重启

前端之家收集整理的这篇文章主要介绍了Linux mysql服务器无法启动或重启前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
介绍

我在我的linux机器上运行MariaDB和Apache,今天我遇到了一些问题.

我通过SSH连接到服务器,这是我面临的一些问题.我完全不知道我在这里做什么.

我在做什么

第1步:mysql -u USERNAME -p

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket
‘/var/run/MysqLd/MysqLd.sock’ (2 “No such file or directory”)

好的,所以我想,让我们尝试停止MysqL服务

第2步:sudo服务MysqL停止

好的,没有错误,所以重启服务

第3步:sudo服务MysqL重启

Job for MysqL.service Failed. See “systemctl status MysqL.service” and
“journalctl -xe” for details.

好的,所以我最好运行这两个命令,然后我得到的东西

第4步:状态MysqL.service

嗯..好吧让我们尝试另一个

第5步:journalctl -xe

No journal files were found.

好的,我在这里迷路了..

MysqL错误日志

150824 14:42:58 MysqLd_safe Starting MysqLd daemon with databases from /var/lib/MysqL
150824 14:42:58 [Note] /usr/sbin/MysqLd (MysqLd 10.0.20-MariaDB-0ubuntu0.15.04.1) starting as process 22637 ...
150824 14:42:58 [ERROR] MysqLd: File '/var/lib/MysqL/aria_log_control' not found (Errcode: 13 "Permission denied")
150824 14:42:58 [ERROR] MysqLd: Got error 'Can't open file' when trying to use aria control file '/var/lib/MysqL/aria_log_control'
150824 14:42:58 [ERROR] Plugin 'Aria' init function returned error.
150824 14:42:58 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE Failed.
150824 14:42:58 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150824 14:42:58 [Note] InnoDB: The InnoDB memory heap is disabled
150824 14:42:58 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150824 14:42:58 [Note] InnoDB: Memory barrier is not used
150824 14:42:58 [Note] InnoDB: Compressed tables use zlib 1.2.8
150824 14:42:58 [Note] InnoDB: Using Linux native AIO
150824 14:42:58 [Note] InnoDB: Using cpu crc32 instructions
150824 14:42:58 [Note] InnoDB: Initializing buffer pool,size = 128.0M
150824 14:42:58 [Note] InnoDB: Completed initialization of buffer pool
150824 14:42:58 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode
150824 14:42:58 [ERROR] InnoDB: The system tablespace must be writable!
150824 14:42:58 [ERROR] Plugin 'InnoDB' init function returned error.
150824 14:42:58 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE Failed.
150824 14:42:58 [Note] Plugin 'FeedBACK' is disabled.
150824 14:42:58 [ERROR] Can't open the MysqL.plugin table. Please run MysqL_upgrade to create it.
150824 14:42:58 [ERROR] Unknown/unsupported storage engine: InnoDB
150824 14:42:58 [ERROR] Aborting

150824 14:42:58 [Note] /usr/sbin/MysqLd: Shutdown complete

150824 14:42:58 MysqLd_safe MysqLd from pid file /var/run/MysqLd/MysqLd.pid ended

磁盘空间的问题

它看起来不像磁盘空间是一个问题

解决方法

这就是它没有开始的原因:
150824 14:42:58 [ERROR] MysqLd: File '/var/lib/MysqL/aria_log_control' not found (Errcode: 13 "Permission denied")
150824 14:42:58 [ERROR] MysqLd: Got error 'Can't open file' when trying to use aria control file '/var/lib/MysqL/aria_log_control'

仔细检查/ var / lib / MysqL的权限.另外,请检查系统日志以查看SE-Linux或Apparmor是否在干扰.

猜你在找的Linux相关文章