Mysql error big prob
Posted by: jat1801 (---.ccmtc.com)
Date: April 10, 2008 12:16AM

MySQL said:

#2003 - Can't connect to MySQL server on 'localhost' (10061)

And down at the bottom the wamp server icon isn't all the way green and i try to start mysql but it wont work

Options: ReplyQuote
Re: Mysql error big prob
Posted by: hambuler (---.cpe.net.cable.rogers.com)
Date: April 10, 2008 05:58AM

Tough luck, you should read my post at: [forum.wampserver.com] to pursue the sure-it-work alternative.

If you insist to use Wamp, then look at the mysql log files in wamp\logs folder to see what the errors are.

Options: ReplyQuote
Re: Mysql error big prob
Posted by: yfastud (Moderator)
Date: April 10, 2008 02:18PM

Did you ever have mysql or any other wamp package before?

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: Mysql error big prob
Posted by: droll (85.121.29.---)
Date: April 12, 2008 12:09PM

i have the problem also .and yes i have wamp before , uninstall it and reinstall cuz apache won't start anymore dunno why.

Options: ReplyQuote
Re: Mysql error big prob
Posted by: yfastud (Moderator)
Date: April 12, 2008 01:42PM

Remember to clean wampapache and wampmysql registries before re-installing

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: Mysql error big prob
Posted by: droll (85.121.29.---)
Date: April 13, 2008 12:51PM

"clean wampapache and wampmysql registries "
can't remove them still same problem

Options: ReplyQuote
Re: Mysql error big prob
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: April 13, 2008 01:03PM

go to start , run and go to regedit

click edit and find,,

search for wamp

delete the folder on the left that it finds

search for apache

delete the folder on the left that it finds

search for mysql

if it finds anything delete it

restart and reinstall..




but i find that i never need to do this to reinstall.... whats ur exact problem..?

Options: ReplyQuote
Re: Mysql error big prob
Posted by: droll (85.121.29.---)
Date: April 13, 2008 01:05PM

Can't connect to MySQL server on 'localhost' (10061)
is my problem sad smiley

Options: ReplyQuote
Re: Mysql error big prob
Posted by: droll (85.121.29.---)
Date: April 13, 2008 01:06PM

can't go to phpmyadmin to conf passwords make new db .i want to install phpbb

Options: ReplyQuote
Re: Mysql error big prob
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: April 13, 2008 01:10PM

ok . end wamp completely. makke sure mysql and apache services are not running in task manager,.,


goto C:\wamp\bin\mysql\mysql5.0.45\data\mysql

there are 3 files... USER.MYI USER.FRM USER.MYD

Delete them


copy them off my server..

pampserver.com/mysqlusertable download them here<<<<<<

place them back into the folder


and restart wamp

Options: ReplyQuote
Re: Mysql error big prob
Posted by: droll (85.121.29.---)
Date: April 13, 2008 01:13PM

ok i'll try
thx

Options: ReplyQuote
Re: Mysql error big prob
Posted by: jat1801 (---.ccmtc.com)
Date: April 15, 2008 12:26AM

heres the error log
080414 15:24:08 [ERROR] Default storage engine (InnoDcool smiley is not available
080414 15:24:08 [ERROR] Aborting

080414 15:24:08 [Note] wampmysqld: Shutdown complete

Options: ReplyQuote
Re: Mysql error big prob
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: April 15, 2008 12:38AM

open my.ini and change InnoDB - TO MyISAM AS THE DEFAULT STORAGE ENGINE

Options: ReplyQuote
Re: Mysql error big prob
Posted by: jat1801 (---.ccmtc.com)
Date: April 15, 2008 01:48AM

ok now i have a phpmyadmin error

SQL query: Edit

SHOW FULL FIELDS FROM `cms_help` ;

MySQL said: Documentation
#1 - Can't create/write to file 'C:\xampp\tmp\#sql_cfc_0.MYI' (Errcode: 2)
everyfile database i click it says that

Options: ReplyQuote
Re: Mysql error big prob
Posted by: yfastud (Moderator)
Date: April 15, 2008 02:13AM

You had xampp before and you need to completely clean its registry for wamp to work properly

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: Mysql error big prob
Posted by: jat1801 (---.ccmtc.com)
Date: April 15, 2008 11:53PM

idk how to remove wamp i un installed went into regedit and deleted all that

Options: ReplyQuote
Re: Mysql error big prob
Posted by: Tribune (---.hsd1.ky.comcast.net)
Date: May 26, 2008 08:03AM

This is an old thread, but I thought I would put my 2 cts in..

It's been ny experience that wamp is very forgiving..There are compatiblity problems in certain mixes of Apache/PhP/Mysql. But those are usually do to playing to much.

I have played with wamp for sometime and loaded it down to the ground and recovered gracefully. The only problems I have found is when one is careless about site page configurations and DB/server calls.

The cleaning registry solution should be a last resort solution, but will definetly solve the problem.

But first I would check my firewall to port settings to see if they have changed.

Go here if you have firewall issues and your running xpPro...[support.microsoft.com]

Check The 3 files as suggested by JLBN following his notes.

Undo the last thing you loaded..

Check to see if the required port is being used as suggested above..

Many times we load a program and it runs in idle until we call it again..Check this for interference..

If you have to go to the registery be careful and take it slowly. One deletion can cost you a re-intall..

Do as suggested above for any name related to wamp..Careful here!!! If you have MS SQL installed don't mistake it for MYSQL..Look at each key entry carefully it's normally displayed on the left side.. You may find something like "C:\Navkit\Msql\" That has nothing to do with what you are doing..

After you have purged you registers then take your daily registry cleaner like "The Free windows registry repair tool", and remove the left overs from those purgings of the registry you just did. This will get it all and you will be able to start from scratch like new...

Did not mean to impose on anyone here. JLBN has helped so many it's awesome. I am studying php and the latest VB due to the retirement of VB6. and hopefully someday I will be able to contribute more..Hope this helps anyone.


Options: ReplyQuote
Re: Mysql error big prob
Posted by: yfastud (Moderator)
Date: May 27, 2008 03:00AM

Thanks a lot, Tribune. Nowadays, it's a little rare to find a user that actually show a big appreciation like you ;-)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote


Sorry, only registered users may post in this forum.