首页  >  文章  >  后端开发  >  wamp mysql无法启动

wamp mysql无法启动

WBOY
WBOY原创
2016-06-06 20:15:091101浏览

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

<code>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</code>

求解啊~~

回复内容:

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

<code>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</code>

求解啊~~

解决方案1:
建议你安装xampp。
解决方法2:
wamp系统里面存在my.ini文件,找出来删掉。利用查找文件功能全盘扫描,原来是c盘windows文件夹下存在一个my.ini,果断删除,立即重启wampserver所有服务,试一试。

声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn