Heim  >  Artikel  >  Backend-Entwicklung  >  wamp mysql无法启动

wamp mysql无法启动

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

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

Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn