mysql无法正常运行,请问config.inc.php在哪

问:访问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、云主机】 -> 数据库设置 -> 数据库服务启动失败/使用出错类型工单,我司尝试处理下,谢谢。??

更多关于云服务器域名注册虚拟主机的问题,请访问西部数码官网:www.west.cn
赞(0)
声明:本网站发布的内容(图片、视频和文字)以原创、转载和分享网络内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-62778877-8306;邮箱:fanjiao@west.cn。本站原创内容未经允许不得转载,或转载时需注明出处:西部数码知识库 » mysql无法正常运行,请问config.inc.php在哪

登录

找回密码

注册