问:访问PHPmy显示:
#2002 – ?????????
服务器没有响应(或本地服务器的套接字没有正确设置)。
mysql错误日志:
190821 3:39:11 [Note] Plugin 'FEDERATED' is disabled.
190821 3:39:12 InnoDB: The InnoDB memory heap is disabled
190821 3:39:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190821 3:39:12 InnoDB: Compressed tables use zlib 1.2.3
190821 3:39:15 InnoDB: Initializing buffer pool, size = 128.0M
190821 3:39:20 InnoDB: Completed initialization of buffer pool
190821 3:39:23 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
190821 3:39:24 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files…
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer…
190821 3:39:36 InnoDB: Waiting for the background threads to start
190821 3:39:37 InnoDB: 5.5.54 started; log sequence number
190821 3:39:37 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
190821 3:39:37 [Note] – '127.0.0.1' resolves to '127.0.0.1';
190821 3:39:37 [Note] Server socket created on IP: '127.0.0.1'.
190821 3:39:38 [Note] Event Scheduler: Loaded 0 events
190821 3:39:38 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: ready for connections.
Version: '5.5.54' socket: '/tmp/mysql.sock' port: 3306 Source distribution
190821 3:40:24 [Note] Plugin 'FEDERATED' is disabled.
190821 3:40:24 InnoDB: The InnoDB memory heap is disabled
190821 3:40:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
190821 3:40:24 InnoDB: Compressed tables use zlib 1.2.3
190821 3:40:24 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap bytes) failed; errno 12
190821 3:40:24 InnoDB: Completed initialization of buffer pool
190821 3:40:24 InnoDB: Fatal error: cannot allocate memory for the buffer pool
190821 3:40:24 [ERROR] Plugin 'InnoDB' init function returned error.
190821 3:40:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
190821 3:40:24 [ERROR] Unknown/unsupported storage engine: InnoDB
190821 3:40:24 [ERROR] Aborting
论坛里面说要改config.inc.php
原因: 如果未指定主机名或指定了特殊的主机名localhost,将指向Linux套接字,而源码编译安装的mysql套接字默认是/tmp/mysql.sock,而本机并没有配置这样的套接字文件,所以会出现上述错解决方法根据自己的安装路径,找到config.inc.php文件,编辑打开找到如下行$cfg['Servers'][$i]['host'] = 'localhost';修改为如下$cfg['Servers'][$i]['host'] = '127.0.0.1';然后重新登录即可
请问config.inc.php在哪里?找了大半天找不到。,mysql无法正常运行,请问config.inc.php在哪里?找了大半天找不到。
问:相关帖子链接:https://www.wdlinux.cn/bbs/viewthread.php?tid=56166&highlight=mysql
答:您好,根据mysql报错日志分析,是由于内存不足引起的,请您先尝试重启下服务器再试试启动mysql,如经常出现这个问题,请升级服务器内存。
您当前是独立IP主机,如需我司进入服务器处理,请重新提交正确类型独立IP主机工单,类型选择:??【主机租用 vps、云主机】 -> 数据库设置 -> 数据库服务启动失败/使用出错 ?? ,提交此工单我司会按照服务标准为您处理(处理标准:https://www.west.cn/services/server/vip_vps.asp ),部分问题可能会涉及费用产生,谢谢。
问:请问config.inc.php在哪里?
问:我的内存还剩挺多的啊
问:内存还有1/3
答:您好,建议可在服务器内输入reboot重启试试,phpmy的配置一般不需要修改,出现这个报错的原因是数据库没有启动引起的。
如无法解决,可以提交下【??主机租用 vps、云主机】 -> 数据库设置 -> 数据库服务启动失败/使用出错类型工单,我司尝试处理下,谢谢。??