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/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/MysqL150824 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 pages150824 14:42:58 [Note] InnoDB: The InnoDB memory heap is Disabled150824 14:42:58 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins150824 14:42:58 [Note] InnoDB: Memory barrIEr is not used150824 14:42:58 [Note] InnoDB: Compressed tables use zlib 1.2.8150824 14:42:58 [Note] InnoDB: Using linux native AIO150824 14:42:58 [Note] InnoDB: Using cpu crc32 instructions150824 14:42:58 [Note] InnoDB: Initializing buffer pool,size = 128.0M150824 14:42:58 [Note] InnoDB: Completed initialization of buffer pool150824 14:42:58 [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode150824 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: InnoDB150824 14:42:58 [ERROR] Aborting150824 14:42:58 [Note] /usr/sbin/MysqLd: Shutdown complete150824 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 mysql服务器无法启动或重启全部内容，希望文章能够帮你解决Linux mysql服务器无法启动或重启所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。