Solved

wampmysqld 64 error 1067 the process terminated unexpectedly

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
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 create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

760 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

17 Experts available now in Live!

Get 1:1 Help Now