精华内容
下载资源
问答
  • xp的电脑,刚装wamp2.4,默认端口改了mysql 的没改,点mysql里面的启动没反映,看错误日志如下:2016-03-16 14:18:14 2584 [Note] Plugin 'FEDERATED' is disabled.2016-03-16 14:18:14 2584 [Note] InnoDB: The ...

    xp的电脑,刚装wamp2.4,默认端口改了mysql 的没改,点mysql里面的启动没反映,看错误日志如下:

    2016-03-16 14:18:14 2584 [Note] Plugin 'FEDERATED' is disabled.

    2016-03-16 14:18:14 2584 [Note] InnoDB: The InnoDB memory heap is disabled

    2016-03-16 14:18:14 2584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

    2016-03-16 14:18:14 2584 [Note] InnoDB: Compressed tables use zlib 1.2.3

    2016-03-16 14:18:14 2584 [Note] InnoDB: Not using CPU crc32 instructions

    2016-03-16 14:18:14 2584 [Note] InnoDB: Initializing buffer pool, size = 128.0M

    2016-03-16 14:18:14 2584 [Note] InnoDB: Completed initialization of buffer pool

    2016-03-16 14:18:14 2584 [Note] InnoDB: Highest supported file format is Barracuda.

    2016-03-16 14:18:14 2584 [Note] InnoDB: 128 rollback segment(s) are active.

    2016-03-16 14:18:14 2584 [Note] InnoDB: Waiting for purge to start

    2016-03-16 14:18:14 2584 [Note] InnoDB: 5.6.12 started; log sequence number 1625977

    2016-03-16 14:18:15 2584 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: de1f4d6a-eb3e-11e5-8b86-00247e6db24c.

    2016-03-16 14:18:15 2584 [Note] Server hostname (bind-address): '*'; port: 3306

    2016-03-16 14:18:17 2584 [Note] IPv6 is not available.

    2016-03-16 14:18:17 2584 [Note] - '0.0.0.0' resolves to '0.0.0.0';

    2016-03-16 14:18:17 2584 [Note] Server socket created on IP: '0.0.0.0'.

    2016-03-16 14:18:17 2584 [ERROR] wampmysqld: Can't create/write to file 'D:\wamp\bin\mysql\mysql5.6.12\data\QF*-20160217THL.pid' (Errcode: 22 - Invalid argument)

    2016-03-16 14:18:17 2584 [ERROR] Can't start server: can't create PID file: Invalid argument

    求解啊~~

    展开全文
  • xp的电脑,刚装wamp2.4,默认端口改了mysql 的没改,点mysql里面的启动没反映,看错误日志如下:2016-03-16 14:18:14 2584 [Note] Plugin 'FEDERATED' is disabled.2016-03-16 14:18:14 2584 [Note] InnoDB: The ...

    xp的电脑,刚装wamp2.4,默认端口改了mysql 的没改,点mysql里面的启动没反映,看错误日志如下:

    2016-03-16 14:18:14 2584 [Note] Plugin 'FEDERATED' is disabled.

    2016-03-16 14:18:14 2584 [Note] InnoDB: The InnoDB memory heap is disabled

    2016-03-16 14:18:14 2584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

    2016-03-16 14:18:14 2584 [Note] InnoDB: Compressed tables use zlib 1.2.3

    2016-03-16 14:18:14 2584 [Note] InnoDB: Not using CPU crc32 instructions

    2016-03-16 14:18:14 2584 [Note] InnoDB: Initializing buffer pool, size = 128.0M

    2016-03-16 14:18:14 2584 [Note] InnoDB: Completed initialization of buffer pool

    2016-03-16 14:18:14 2584 [Note] InnoDB: Highest supported file format is Barracuda.

    2016-03-16 14:18:14 2584 [Note] InnoDB: 128 rollback segment(s) are active.

    2016-03-16 14:18:14 2584 [Note] InnoDB: Waiting for purge to start

    2016-03-16 14:18:14 2584 [Note] InnoDB: 5.6.12 started; log sequence number 1625977

    2016-03-16 14:18:15 2584 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: de1f4d6a-eb3e-11e5-8b86-00247e6db24c.

    2016-03-16 14:18:15 2584 [Note] Server hostname (bind-address): '*'; port: 3306

    2016-03-16 14:18:17 2584 [Note] IPv6 is not available.

    2016-03-16 14:18:17 2584 [Note] - '0.0.0.0' resolves to '0.0.0.0';

    2016-03-16 14:18:17 2584 [Note] Server socket created on IP: '0.0.0.0'.

    2016-03-16 14:18:17 2584 [ERROR] wampmysqld: Can't create/write to file 'D:\wamp\bin\mysql\mysql5.6.12\data\QF*-20160217THL.pid' (Errcode: 22 - Invalid argument)

    2016-03-16 14:18:17 2584 [ERROR] Can't start server: can't create PID file: Invalid argument

    求解啊~~

    展开全文
  • wamp Mysql无法启动

    2013-05-28 13:41:00
    (尝试安装新版wamp看是否成功,一般是mysql无法启动了)。 3.关键步骤: 到regedit把注册表,删除 HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL HKEY_...

    如题,遇到多次安装wamp或者独立的mysql后无法启动mysql的童鞋可以往下看~ 

    我是原本已经安装了mysql,导致wamp安装成功后无法启动mysql服务。

    下面是我综合网上搜索的资料整理的解决方法:

    1.必要的数据备份工作。

    2.卸载mysql。(尝试安装新版wamp看是否成功,一般是mysql无法启动了)。

    3.关键步骤:到regedit把注册表,删除

    • HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL
    • HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL
    • HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL

    4.到c盘C:\Program Files目录下把MySQL目录删除(如果在其他盘还有设置目录也要删除.空目录也要删除)


    转载于:https://my.oschina.net/koybe/blog/133919

    展开全文
  • WAMP mysql 无法启动的解决方法

    千次阅读 2013-11-26 19:20:15
    WAMP mysql 无法启动,手动启动wampmysqld进程报1067的错误。 通过查看mysql log,发现 2013-11-26 19:04:11 5068 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace user...

    WAMP mysql 无法启动,手动启动wampmysqld进程报1067的错误。

    通过查看mysql log,发现

    2013-11-26 19:04:11 5068 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace usernet/message uses space ID: 9 at filepath: .\usernet\message.ibd. Cannot open tablespace usernet/messages which uses space ID: 9 at filepath: .\usernet\messages.ibd
    2013-11-26 19:04:11 13b4  InnoDB: Operating system error number 997 in a file operation.
    InnoDB: Some operating system error numbers are described at
    InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
    InnoDB: Error: could not open single-table tablespace file .\usernet\messages.ibd
    InnoDB: We do not continue the crash recovery, because the table may become
    InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
    InnoDB: To fix the problem and start mysqld:
    InnoDB: 1) If there is a permission problem in the file and mysqld cannot
    InnoDB: open the file, you should modify the permissions.
    InnoDB: 2) If the table is not needed, or you can restore it from a backup,
    InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
    InnoDB: crash recovery and ignore that table.
    InnoDB: 3) If the file system or the disk is broken, and you cannot remove
    InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
    InnoDB: and force InnoDB to continue crash recovery here.

    由于数据不重要,我选择删除 messages.ibd 

    重启wamp server 正常启动

    展开全文
  • wamp mysql无法启动,出现1067错误

    千次阅读 2016-11-24 09:22:31
    删除wamp里面mysql安装目录中,mysql bin目录下Data目录中的ib_logfile0和ib_logfile1
  • wampmysql无法启动的解决办法:1、通过设置环境变量,开启MySQL服务;2、在启动wampserver之前把MySQL服务停掉;3、在my.ini中添加或修改“innodb_force_recovery=1”等等。wampserver三个服务(apache+php+MySQL)...
  • 前两天系统崩溃了重新安装wamp5的时候遭遇了mysql无法启动的问题。大部分时候我们都会先检查端口问题,例如讯雷/iis什么的都可能会影响wamp5中的mysql正常使用。所以我们在启动wamp之前要先关闭掉会占用我们端口的...
  • 安装wampmysql无法启动问题

    千次阅读 2017-03-26 15:07:55
    安装wampmysql无法启动问题最近发现安装wamp之后,如果电脑突然关机wamp中的MySQL无法正常启动的解决方案:删除wamp/bin/mysql/data目录下的ib_logfile0和ib_logfile1两个文件。完美解决。
  • wamp mysql服务无法启动

    2015-06-21 10:47:13
    删除mysql文件夹下的ib_logfile0和ib_logfile1
  • 如果不是首次安装wamp或着mysql,可能会遇到安装后无法启动的问题。我是由于升级wamp,升级后无法启动mysql服务。 下面是我的解决方法: ...(尝试安装新版wamp看是否成功,一般是mysql无法启动了)。
  • 一直用的都是wamp2.4,在玩单机魔域的时候又安装了一个mysql,结果原来的那个不能用了,卸载重装后也不能用,下面是mysq的日志2015-02-2416:02:031060[Note]Plugin'FEDERATED'isdisab...一直用的都是wamp2.4 ,在玩...
  • 有次公司突然断电,导致wamp mysql无法重启 二 分析 初步估计是mysql日志损坏问题,从日志内容分析来看,数据库在机器crash 导致日志文件损坏,重启之后无法正常恢复,更无法正常对外提供服务。三 解决 因为日志已经...
  • 新版WampMySQL服务无法启动的解决方案 遇到的问题 安装完Wamp3.2.0之后图标始终是黄色,总是不能变绿。检查之后发现,MySQL服务没有启动。 无论是在wamp中手动启动,还是去服务里手动启动都是失败。 我的环境 安装...
  • wampmysql无法启动的解决办法:1、通过设置环境变量,开启MySQL服务;2、在启动wampserver之前把MySQL服务停掉;3、在my.ini中添加或修改“innodb_force_recovery=1”等等。推荐:《mysql视频教程》wampserver三个...
  • WAMP 图标橙色 MYSQL无法启动解决方案

    千次阅读 2019-04-06 09:46:09
    昨天倒腾了好久终于能启动Apache了,今天MYSQL又有问题了;) 解决方案:首先查看了一下mysql的日志文件,发现: 2019-04-06T01:15:24.677276Z 0 [ERROR] Can’t start server: Bind on TCP/IP port: No such file ...
  • Wampserver安装完成后无法启动MySQL这有可能是你之前安装过MysqL,因为wampserver内置MySQL。解决的方法就是配置环境变量。 找到我的电脑或计算机右键,打开属性,然后打开高级系统设置, 然后是环境变量 ...
  • mysql启动不了
  • wamp 安装之后无法启动mysql

    千次阅读 2015-04-29 17:56:42
    安装完wamp之后,无法启动mysql,检查端口和配置都没有问题,最后在c盘检索了一下,c盘windows里面找到了my.ini.最后将该文件删除之后,mysql可以正常启动。
  • 主要介绍了wampmysql安装时能启动重启后无法启动的解决办法 ,需要的朋友可以参考下
  • wamp的mysql服务前两天还能用,今天突然不能无法启动了,原因可能是近期电脑...另外附上安装WAMPmysql无法启动的解决方法, 找到我的电脑或计算机右键,打开属性,然后打开高级系统设置, 然后是环境变量...
  • 今天重启一下wamp,突然发现无法启动,图标一直是黄色 排除php和mysql的问题 在系统服务里发现wampapache服务无法启动,联想到可以是之前修改apache的配置文件时改错了 找错方法: 通过cmd命令进入httpd.exe所在...
  • Shutting down plugin 'sha256_password' 2016-04-06 17:10:40 6276 [Note] Shutting down plugin 'mysql_old_password' 2016-04-06 17:10:40 6276 [Note] Shutting down plugin 'mysql_native_password' 2016-04-...
  • <p>I had installed <code>wamp</code> server successfully but after starting all services it's not turning into green. I don't know exact problem also there is no port blocking problem. <p>Default ...
  • 再次启动电脑后,wampserver中的Mysql服务无法启动,于是百度了一下, 找到了解决办法。 首先进入到wamp\bin\mysql\mysql5.6.17\data 的目录下, 然后删除掉ib_logfile0和ib_logfile1两个文件, 再次重启...
  • WAMP Server 无法启动的解决方法

    千次阅读 2015-09-04 09:45:54
    今天安装WAMP SERVER用于发布PHP+MySQL做的网站,可安装完后服务不能启动。本文主要解决由于80端口被占而Apache服务不能启动的方法。
  • WAMP不能启动MYSQL服务

    2014-06-15 13:43:00
    PHP集成环境WAMPMYSQL的服务wampmysqld无法启动,总是提示 错误1067:进程意外终止! 具体什么原因我也没有找到,只有在百度上找到了方法。 理解到的: (1)通过 netstat -a -n 看到MySql端口并未被占,所以...
  • 首先通过wamp启动mysql apache 发现Apache起不来。 启动时报错; --------------------------------------------------------------------------------------------- 这样的错误是给非开发人员看的,极其不具体...

空空如也

空空如也

1 2 3 4 5 6
收藏数 115
精华内容 46
关键字:

wampmysql无法启动

mysql 订阅