We help IT Professionals succeed at work.

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

qeng
qeng asked
on
Medium Priority
3,935 Views
Last Modified: 2012-05-06
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
Comment
Watch Question

Michael WorshamCloud/Infrastructure Solutions Architect
CERTIFIED EXPERT
Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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.
Cloud/Infrastructure Solutions Architect
CERTIFIED EXPERT
Commented:
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.

Author

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.
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
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.