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 disabled2016-03-16 14:18:14 2584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-03-16 14:18:14 2584 [Note] InnoDB: Compressed tables use zlib 1.2.32016-03-16 14:18:14 2584 [Note] InnoDB: Not using CPU crc32 instructions2016-03-16 14:18:14 2584 [Note] InnoDB: Initializing buffer pool, size = 128.0M2016-03-16 14:18:14 2584 [Note] InnoDB: Completed initialization of buffer pool2016-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 start2016-03-16 14:18:14 2584 [Note] InnoDB: 5.6.12 started; log sequence number 16259772016-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: 33062016-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 InnoDB memory heap is disabled2016-03-16 14:18:14 2584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2016-03-16 14:18:14 2584 [Note] InnoDB: Compressed tables use zlib 1.2.32016-03-16 14:18:14 2584 [Note] InnoDB: Not using CPU crc32 instructions2016-03-16 14:18:14 2584 [Note] InnoDB: Initializing buffer pool, size = 128.0M2016-03-16 14:18:14 2584 [Note] InnoDB: Completed initialization of buffer pool2016-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 start2016-03-16 14:18:14 2584 [Note] InnoDB: 5.6.12 started; log sequence number 16259772016-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: 33062016-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
求解啊~~
解決方案1:
建議你安裝xampp。
解決方案2:
wamp系統裡面存在my.ini檔案,找出來刪掉。利用尋找檔案功能全盤掃描,原來是c盤windows檔案夾下存在一個my.ini,果斷刪除,立即重啟wampserver所有服務,試一試。