Solved

wampmysqld 64 error 1067 the process terminated unexpectedly

Posted on 2014-10-09
4
4,655 Views
Last Modified: 2014-10-09
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.
0
Comment
Question by:Jason Yu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 

Author Comment

by:Jason Yu
ID: 40370171
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
 
LVL 34

Accepted Solution

by:
Beverley Portlock earned 500 total points
ID: 40370251
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
 

Author Comment

by:Jason Yu
ID: 40371493
HI, Beverley:

I resolved it successfully by re-installing wampServer bundle. It works great now, thank you for your help.
0
 
LVL 34

Expert Comment

by:Beverley Portlock
ID: 40371859
I am glad it is sorted out for you. Thank you for the points.
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
&& operators not performing required logic 8 40
XML loaded in a form with dropdown 6 52
SQL Function 4 38
phpmyadmin memory error 55 92
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This article discusses how to implement server side field validation and display customized error messages to the client.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question