Solved

wampmysqld 64 error 1067 the process terminated unexpectedly

Posted on 2014-10-09
4
4,728 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

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
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…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

688 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