Link to home
Start Free TrialLog in
Avatar of qeng
qeng

asked on

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
SOLUTION
Avatar of Michael Worsham
Michael Worsham
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of qeng
qeng

ASKER

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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of qeng

ASKER

WAMPSERVER2 is the update to WAMP5 (which you probably knew).
I'll give XAMPP a shot and get back to you on it.
Thx.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial