wampmysqld 64 error 1067 the process terminated unexpectedly

After I installed WAMPServer, I can start apache and php module. However, the mysql part can't work. I tried to access phpmyadmin by accessing http://localhost/phpmyadmin/, but it gave me 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).


Then, I checked the services.msc list and found the "wampmysqld64" service is not started. I tried to start it but got the error:

Error 1067; The process terminated unexpectedly.

There is no mysql log created in log folder, please help.
Jason YuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason YuAuthor Commented:
I found a log file named jason-PC.err under C:\wamp\bin\mysql\mysql5.6.17\data, it has the following error. It looks like my IPv6 was enabled, how could disable it/

thanks.

2014-10-09 00:56:20 6456 [Note] InnoDB: 128 rollback segment(s) are active.
2014-10-09 00:56:20 6456 [Note] InnoDB: Waiting for purge to start
2014-10-09 00:56:20 6456 [Note] InnoDB: 5.6.17 started; log sequence number 1626343
2014-10-09 00:56:20 6456 [Note] Server hostname (bind-address): '*'; port: 3306
2014-10-09 00:56:20 6456 [Note] IPv6 is available.
2014-10-09 00:56:20 6456 [Note]   - '::' resolves to '::';
2014-10-09 00:56:20 6456 [Note] Server socket created on IP: '::'.
2014-10-09 00:56:20 6456 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'user' (errno: 2 - No such file or directory)
2014-10-09 00:59:21 6632 [Note] Plugin 'FEDERATED' is disabled.
2014-10-09 00:59:21 6632 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-09 00:59:21 6632 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-09 00:59:21 6632 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-09 00:59:21 6632 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-09 00:59:21 6632 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-09 00:59:21 6632 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-10-09 00:59:21 6632 [Note] InnoDB: Completed initialization of buffer pool
2014-10-09 00:59:21 6632 [Note] InnoDB: Highest supported file format is Barracuda.
2014-10-09 00:59:21 6632 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625987
2014-10-09 00:59:21 6632 [Note] InnoDB: Database was not shutdown normally!
2014-10-09 00:59:21 6632 [Note] InnoDB: Starting crash recovery.
2014-10-09 00:59:21 6632 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-10-09 00:59:21 6632 [Note] InnoDB: Restoring possible half-written data pages 
2014-10-09 00:59:21 6632 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626353
2014-10-09 00:59:21 6632 [Note] InnoDB: 128 rollback segment(s) are active.
2014-10-09 00:59:21 6632 [Note] InnoDB: Waiting for purge to start
2014-10-09 00:59:21 6632 [Note] InnoDB: 5.6.17 started; log sequence number 1626353
2014-10-09 00:59:21 6632 [Note] Server hostname (bind-address): '*'; port: 3306
2014-10-09 00:59:21 6632 [Note] IPv6 is available.
2014-10-09 00:59:21 6632 [Note]   - '::' resolves to '::';
2014-10-09 00:59:21 6632 [Note] Server socket created on IP: '::'.
2014-10-09 00:59:21 6632 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'user' (errno: 2 - No such file or directory)
2014-10-09 01:03:37 6212 [Note] Plugin 'FEDERATED' is disabled.
2014-10-09 01:03:37 6212 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-09 01:03:37 6212 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-09 01:03:37 6212 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-09 01:03:37 6212 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-09 01:03:37 6212 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-09 01:03:37 6212 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-10-09 01:03:37 6212 [Note] InnoDB: Completed initialization of buffer pool
2014-10-09 01:03:37 6212 [Note] InnoDB: Highest supported file format is Barracuda.
2014-10-09 01:03:37 6212 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625987
2014-10-09 01:03:37 6212 [Note] InnoDB: Database was not shutdown normally!
2014-10-09 01:03:37 6212 [Note] InnoDB: Starting crash recovery.
2014-10-09 01:03:37 6212 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-10-09 01:03:37 6212 [Note] InnoDB: Restoring possible half-written data pages 
2014-10-09 01:03:37 6212 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626363
2014-10-09 01:03:38 6212 [Note] InnoDB: 128 rollback segment(s) are active.
2014-10-09 01:03:38 6212 [Note] InnoDB: Waiting for purge to start
2014-10-09 01:03:38 6212 [Note] InnoDB: 5.6.17 started; log sequence number 1626363
2014-10-09 01:03:38 6212 [Note] Server hostname (bind-address): '*'; port: 3306
2014-10-09 01:03:38 6212 [Note] IPv6 is available.
2014-10-09 01:03:38 6212 [Note]   - '::' resolves to '::';
2014-10-09 01:03:38 6212 [Note] Server socket created on IP: '::'.
2014-10-09 01:03:38 6212 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'user' (errno: 2 - No such file or directory)
2014-10-09 01:13:44 5520 [Note] Plugin 'FEDERATED' is disabled.
2014-10-09 01:13:44 5520 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-09 01:13:44 5520 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-09 01:13:44 5520 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-09 01:13:44 5520 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-09 01:13:44 5520 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-09 01:13:44 5520 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-10-09 01:13:44 5520 [Note] InnoDB: Completed initialization of buffer pool
2014-10-09 01:13:44 5520 [Note] InnoDB: Highest supported file format is Barracuda.
2014-10-09 01:13:44 5520 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625987
2014-10-09 01:13:44 5520 [Note] InnoDB: Database was not shutdown normally!
2014-10-09 01:13:44 5520 [Note] InnoDB: Starting crash recovery.
2014-10-09 01:13:44 5520 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-10-09 01:13:44 5520 [Note] InnoDB: Restoring possible half-written data pages 
2014-10-09 01:13:44 5520 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626373
2014-10-09 01:13:44 5520 [Note] InnoDB: 128 rollback segment(s) are active.
2014-10-09 01:13:44 5520 [Note] InnoDB: Waiting for purge to start
2014-10-09 01:13:44 5520 [Note] InnoDB: 5.6.17 started; log sequence number 1626373
2014-10-09 01:13:44 5520 [Note] Server hostname (bind-address): '*'; port: 3306
2014-10-09 01:13:44 5520 [Note] IPv6 is available.
2014-10-09 01:13:44 5520 [Note]   - '::' resolves to '::';
2014-10-09 01:13:44 5520 [Note] Server socket created on IP: '::'.
2014-10-09 01:13:44 5520 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'user' (errno: 2 - No such file or directory)

Open in new window

0
Beverley PortlockCommented:
The thing that stands out for me from that logfile is this line

Fatal error: Can't open and lock privilege tables: Can't find file: 'user' (errno: 2 - No such file or directory)

This seems to be common enought that MySQL have a page for resolving it http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooting.html

It says that "These messages often occur when the MySQL base or data directories are installed in different locations than the default locations " so perhaps that is your issue, not IPv6

Also it says ...

"If you have installed MySQL to a directory other than C:\Program Files\MySQL\MySQL Server 5.0, you need to ensure that the MySQL server is aware of this through the use of a configuration (my.ini) file. The my.ini file needs to be located in your Windows directory, typically C:\WINDOWS. You can determine its exact location from the value of the WINDIR environment variable by issuing the following command from the command prompt: "
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jason YuAuthor Commented:
HI, Beverley:

I resolved it successfully by re-installing wampServer bundle. It works great now, thank you for your help.
0
Beverley PortlockCommented:
I am glad it is sorted out for you. Thank you for the points.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.