WampServer

I have had WampServer working fine for quite a while now but for some reason I now have a problem connecting to MySQL.

This is the error I get when I try to open /localhost/mysite:
--------------------
"Database Error: Unable to connect to the database:Could not connect to MySQL"
--------------------

This is the error I get when I try to open phpMyAdmin:
--------------------
"MySQL said: #2003 - Can't connect to MySQL server on 'localhost' (10061)
--------------------

The WampServer icon in the system tray is partly coloured yellow indicating I presume a problem with the MySQL service in WampServer.

Any help is appreciated. Thank you!

open c:/wamp/logs/ mysql and post the mysql log up here

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Well it appears MySQL isn't even starting because there is no entry in the MySQL log for todays date - only for the last successful attempt a few days ago.

to me happened the same.
My log:
12:33 14/10/2008081014 11:38:11 [ERROR] Default storage engine (InnoD is not available
081014 11:38:11 [ERROR] Aborting

081014 11:38:11 [Note] wampmysqld: Shutdown complete

081014 11:39:26 [ERROR] Default storage engine (InnoD is not available
081014 11:39:26 [ERROR] Aborting

081014 11:39:26 [Note] wampmysqld: Shutdown complete

081014 12:00:52 [ERROR] Default storage engine (InnoD is not available
081014 12:00:52 [ERROR] Aborting

081014 12:00:52 [Note] wampmysqld: Shutdown complete

081014 12:02:25 [ERROR] Default storage engine (InnoD is not available
081014 12:02:25 [ERROR] Aborting

081014 12:02:25 [Note] wampmysqld: Shutdown complete

081014 12:02:37 [ERROR] Default storage engine (InnoD is not available
081014 12:02:37 [ERROR] Aborting

081014 12:02:37 [Note] wampmysqld: Shutdown complete

081014 12:05:02 [ERROR] Default storage engine (InnoD is not available
081014 12:05:02 [ERROR] Aborting

081014 12:05:02 [Note] wampmysqld: Shutdown complete

081014 12:05:10 [ERROR] Default storage engine (InnoD is not available
081014 12:05:10 [ERROR] Aborting

081014 12:05:10 [Note] wampmysqld: Shutdown complete

081014 12:06:35 [ERROR] Default storage engine (InnoD is not available
081014 12:06:35 [ERROR] Aborting

081014 12:06:35 [Note] wampmysqld: Shutdown complete

081014 12:06:44 [ERROR] Default storage engine (InnoD is not available
081014 12:06:44 [ERROR] Aborting

081014 12:06:44 [Note] wampmysqld: Shutdown complete

081014 12:14:28 [ERROR] Default storage engine (InnoD is not available
081014 12:14:28 [ERROR] Aborting

081014 12:14:28 [Note] wampmysqld: Shutdown complete

081014 12:14:34 [ERROR] Default storage engine (InnoD is not available
081014 12:14:34 [ERROR] Aborting

081014 12:14:34 [Note] wampmysqld: Shutdown complete

081014 12:23:41 [ERROR] Default storage engine (InnoD is not available
081014 12:23:41 [ERROR] Aborting

081014 12:23:41 [Note] wampmysqld: Shutdown complete

081014 12:30:53 [ERROR] Default storage engine (InnoD is not available
081014 12:30:53 [ERROR] Aborting

081014 12:30:53 [Note] wampmysqld: Shutdown complete

081014 12:31:00 [ERROR] Default storage engine (InnoD is not available
081014 12:31:00 [ERROR] Aborting

081014 12:31:00 [Note] wampmysqld: Shutdown complete

What should i do? Thanks

this is not the same error prometteus. just open c:/wamp/bin.mysql/msql5.0.1/my.ini

change the


default stoarage engine = INNODB

to

default stoarage engine = My ISAM



save and restart

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Getting back to my original problem, the MySQL service still does not start when I run WanpServer and I cannot start it manually through the system tray menu option.

If any one has any ideas I am very greatful.

Otherwise, I would like to do a new installation of WampServer on a fresh installation of Windows. How can I backup my data without phpmyadmin since it will not open? Can I backup by copying the MySQL files in the data directory?

I really appreciate your help!

Cheers,
Marty

Hey, i have the same problem too. In Vista Home premium, i've installed WAMP server but could not access the phpmyadmin. When i open it i get the message
MySQL said: #2003 - Can't connect to MySQL server on 'localhost' (10061)

But my.ini says mysql is listening on another port number. These are the contents of the mysql log file.


081106 13:25:41 InnoDB: Started; log sequence number 0 43655
081106 13:25:41 [ERROR] listen() on TCP/IP failed with error 6
081106 13:25:41 [ERROR] Aborting

081106 13:25:41 InnoDB: Starting shutdown...
081106 13:25:43 InnoDB: Shutdown completed; log sequence number 0 43655
081106 13:25:43 [Note] wampmysqld: Shutdown complete

081106 13:26:00 InnoDB: Started; log sequence number 0 43655
081106 13:26:00 [ERROR] listen() on TCP/IP failed with error 6
081106 13:26:00 [ERROR] Aborting

081106 13:26:00 InnoDB: Starting shutdown...
081106 13:26:02 InnoDB: Shutdown completed; log sequence number 0 43655
081106 13:26:02 [Note] wampmysqld: Shutdown complete

081106 13:26:03 InnoDB: Started; log sequence number 0 43655
081106 13:26:03 [ERROR] listen() on TCP/IP failed with error 6
081106 13:26:03 [ERROR] Aborting

081106 13:26:03 InnoDB: Starting shutdown...
081106 13:26:05 InnoDB: Shutdown completed; log sequence number 0 43655
081106 13:26:05 [Note] wampmysqld: Shutdown complete

081106 13:26:55 InnoDB: Started; log sequence number 0 43655
081106 13:26:55 [ERROR] listen() on TCP/IP failed with error 6
081106 13:26:55 [ERROR] Aborting

081106 13:26:55 InnoDB: Starting shutdown...
081106 13:26:58 InnoDB: Shutdown completed; log sequence number 0 43655
081106 13:26:58 [Note] wampmysqld: Shutdown complete

081106 13:30:23 InnoDB: Started; log sequence number 0 43655
081106 13:30:23 [ERROR] listen() on TCP/IP failed with error 6
081106 13:30:23 [ERROR] Aborting

081106 13:30:23 InnoDB: Starting shutdown...
081106 13:30:25 InnoDB: Shutdown completed; log sequence number 0 43655
081106 13:30:25 [Note] wampmysqld: Shutdown complete




Any help would be grateful.

DId u change mysqls port? or do u have skype?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

stevenmartin99 Wrote:
-------------------------------------------------------
> DId u change mysqls port? or do u have skype?

I have the same issue with XP Pro SP3. And yes, I have Skype.

When attempting to manually start MySQL, I get the error:
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

Edit: I realize now that I have MySQL already installed for another project. What is the default password that the WampServer expects the server to be?

Edit2: To answer my own question, WAMP defaults MySQL to no password.
Also, my error is too many MySQL instances on port 3306



Edited 4 time(s). Last edit at 11/07/2008 08:53PM by lwatts.

denied for user 'ODBC'@'localhost'

this shows that ur connecting to another mysql version thats not on wamp.. ul need to deleete or at least change wamps mysql port number before you do anything

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]