WampServer

Apparently I'm facing the problem to start the wampmysqld service on Local Computer. I had use netstat to check the port 3306 but it is not listed there. I also searched pc for my.ini but there's only 1 file which is listed in wamp folder so i didn't see any problem on this. When I search for wampmysqld64 in services window, it shows that it is not running so I tried to click start but error prompt (Error 1067: The process terminate unexpectedly) while the wampapache64 is running.

I've uninstalled Skype which I thought might be the cause of the problem. I've also tried to test port from apache and it shows that the port 80 is using by apache 2.4.9 and php 5.5.12. Until now I couldn't figure out what to do and the wamp manager icon is still orange. I didn't face this prob in the past few months and it just suddenly appeared. Can anyone please help? I'm new to this. Thank you!

1 - Windows 8.1 (64 bit)
2 - WampServer 2.5 (64 bit)
3 - Apache 2.4.9
4 - PHP 5.5.12
5 - MySQL 5.6.17
6 - WampServer icon (orange)



Edited 2 time(s). Last edit at 11/03/2015 02:24PM by kiko.

Hi,

- 1 - READ BEFORE YOU ASK A QUESTION

- 2 - TROUBLESHOOTING TIPS

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Already update my question. Please help thanks!

Hi,

Please don't edit previous message, answer into a new message.

Do you read and apply item number - 2 - ?

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Yup already followed and tried but didn't works

- installed at c:\ and run as admin
- uninstalled skype
- checked from the services manager : wampmysqld64 services (not running) & wampapache (started)
- other sql services found (by default all of these are not running, will these affect the wampmysql64 service?):
a. SQL active directory helper
b. SQL server (SQLEXPRESS)
c. SQL server agent (SQLEXPRESS)
d. SQL server browser
e. SQL server VSS writer
- checked php.ini : found in wamp php folder and apache folder
- checked my.ini : found in wamp mysql folder
- turned off IIS in control panel
- error log in mysql:

2015-11-04 08:39:52 3344 [Note] Plugin 'FEDERATED' is disabled.
2015-11-04 08:39:52 3344 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-11-04 08:39:52 3344 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-04 08:39:52 3344 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-04 08:39:52 3344 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-04 08:39:52 3344 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-04 08:39:52 3344 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-11-04 08:39:52 3344 [Note] InnoDB: Completed initialization of buffer pool
2015-11-04 08:39:52 3344 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-04 08:39:52 3344 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1626524
2015-11-04 08:39:52 3344 [Note] InnoDB: Database was not shutdown normally!
2015-11-04 08:39:52 3344 [Note] InnoDB: Starting crash recovery.
2015-11-04 08:39:52 3344 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-11-04 08:39:52 3344 [Note] InnoDB: Restoring possible half-written data pages
2015-11-04 08:39:52 3344 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626574
2015-11-04 08:39:52 3344 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-04 08:39:52 3344 [Note] InnoDB: Waiting for purge to start
2015-11-04 08:39:52 3344 [Note] InnoDB: 5.6.17 started; log sequence number 1626574
2015-11-04 08:39:52 3344 [Note] Recovering after a crash using mysql-bin
2015-11-04 08:39:52 3344 [Note] Starting crash recovery...
2015-11-04 08:39:52 3344 [Note] Crash recovery finished.
2015-11-04 08:39:52 3344 [Note] Server hostname (bind-address): '*'; port: 3306
2015-11-04 08:39:52 3344 [Note] IPv6 is available.
2015-11-04 08:39:52 3344 [Note] - '::' resolves to '::';
2015-11-04 08:39:52 3344 [Note] Server socket created on IP: '::'.
2015-11-04 08:39:52 3344 [ERROR] wampmysqld64: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\a?n??.pid' (Errcode: 22 - Invalid argument)
2015-11-04 08:39:52 3344 [ERROR] Can't start server: can't create PID file: Invalid argument

- access to phpmyadmin show error:#2002 - No connection could be made because the target machine actively refused it. The server is not responding (or the local server's socket is not correctly configured).

FYI: i'm not using innodb; i'm using myisam

I've finally found the cause of this problem. It seems that I've changed my computer name and it couldn't read the name due to the text formatting. It's my own silly mistake and I've learned from it. I apologise for not being careful. I will be in the future to prevent from those mistake. Anyway thank you. You may delete my thread ^^