Home  >  Article  >  Backend Development  >  wamp mysql无法启动

wamp mysql无法启动

WBOY
WBOYOriginal
2016-06-06 20:15:091070browse

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所有服务,试一试。

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn