Rumah > Artikel > pembangunan bahagian belakang > wamp mysql无法启动
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所有服务,试一试。