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

Posted on 2009-02-18
Last Modified: 2012-05-06
Installed WAMPSERVER 2 from / (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 ... 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.

Question by:qeng
    LVL 29

    Assisted Solution

    by:Michael W
    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.

    Author Comment

    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 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.
    LVL 29

    Accepted Solution

    I haven't installed wampserver2 before. I am more familiar with XAMPP ( as it is easier to use, configure and is considered an all-in-one package deal.

    Author Comment

    WAMPSERVER2 is the update to WAMP5 (which you probably knew).
    I'll give XAMPP a shot and get back to you on it.
    LVL 1

    Assisted Solution

    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

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    If your site has a few sections that need to be secure when data is transmitted between the server and local computer, such as a /order/ section for ordering or /customer/ which contains customer data, etc it would of course be recommended to secure…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    746 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

    15 Experts available now in Live!

    Get 1:1 Help Now