介绍
我在我的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.
好的,我在这里迷路了..
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是否在干扰.