• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3304
  • Last Modified:

WAMPSERVER 2 Error: mysqld.exe has encountered a problem and needs to close...

Installed WAMPSERVER 2 from /www.wampserver.com (this installs Apache 2.2.11; MySQL 5.1.30; PHP 5.2.8) to run as a localhost on my Windows XP SP3 PC.

Installation seemed to complete normally but on trying to run WAMPSERVER 2 on my local machine, I get the following error:

"mysqld.exe has encountered a problem and needs to close.  We are sorry for the inconvenience."

I tried:

a) Rebooting computer.
b) Re-downloaded MySQL 5.1.30 alone.
c) Left-clicking WAMPSERVER tray icon 'Restart All Services' ... get same error.
d) Start > Run > services.msc ... could not find MySQL in list.
e) Could not find any evidence of MySQL installation (e.g. no 'C:\Program Files\MySQL' directory)
f) Installed 'mysql-essential-5.1.31-win32.msi.asc' from www.mysql.com ... now My SQL shows up as an installed app as does the MySQL service (as per d) above).
g) However, running WAMPSERVER still generates '"mysqld.exe has encountered a problem and needs to close" error.

Any idea what I'm doing wrong. New to this so may have overlooked something stupid.

Thx
0
qeng
Asked:
qeng
  • 2
  • 2
3 Solutions
 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
MySQL 5.1 is known for having several bugs in it (even though it was recently released), especially under the Windows platform. I recommend falling back to MySQL 5.0 if at all possible.
0
 
qengAuthor Commented:
Thx for replying mwe.
It looks like wampserver2 is designed to let a user install different versions of apps.  Do you know if that is the case (in this instance i would try to install MySQL 5.0 and have it co-exist with MySQL 5.1 on my computer)?  If so, how would I go about installing an earlier version of MySQL without overwriting the latest one?
For whatever reason my initial problem seemed to be that the wampserver2 package when I installed it, didn't install MySQL at all.  After doing a separete install of MySQL from www.mysql.com I tried again to install joomla and this time the installation did complete (past where I was previously getting the mysql error).  I was able to install the sample joomla data without trouble (suggesting that it was at least pulling itssample data correctly from the mysql db).  Now, I still get the mysqld.exe error if I try to Restart All Services but otherwise I seem to be able to develop the joomla site without trouble.
Even though I've been able to install templates and add content to my trial site running on localhost, the wampserver2 icon is still showing 'yellow' as though there is an error somewhere although the consequences of this error are not evident to me at the moment.
So at this point I'm not sure if there is a problem which still persists or if it's just the wampserver2 tray icon software which is mis-representing a problem which doesn't exist.
Either way I would be pleased to try to install an earlier MySQL version as you suggest if that is possible.
Thx.
0
 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
I haven't installed wampserver2 before. I am more familiar with XAMPP (http://www.apachefriends.org/en/xampp.html) as it is easier to use, configure and is considered an all-in-one package deal.
0
 
qengAuthor Commented:
WAMPSERVER2 is the update to WAMP5 (which you probably knew).
I'll give XAMPP a shot and get back to you on it.
Thx.
0
 
MaximeLabelleCommented:
I got that bug on my xp netbook.
Wamp work fine on my vista-desktop computer but not on my xp.
Tryed several thing to solve that, navigate several solution, none
was working.
The easiest fix???
switching to xampp
-easy to install
-you just need to configure some security option to make your install secure

I pratically sure that if drop wamp for xampp, you will be more than happy

Hope this help you
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now