Solved

wampmysqld 64 error 1067 the process terminated unexpectedly

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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…
The viewer will learn how to count occurrences of each item in an array.

863 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now