mySQL - open, beep, close

[Dave987]

Hi all. When just running mySQL from C:\mySQL\bin - I get mySQL pop open , a beep , flash of an error message , and then it closes.

When opened from a command prompt, the error message is this:

ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)


After a brief search on the forums , I couldn't find a solution, so ..
I thought it could have been something to do with winmysqladmin being on the red traffic light , but when I tried to Start this Service, it decided to flash green, and go red again.

Any help is appreciated. I cannot reinstall mySQL because the damn SETUP.exe wont work! :evil:

Thanks for your help!

[m0oni9]

Instead of running mysql as a service, you should be able to run "mysqld". See if that gives any sort of errors.

[Dave987]

When should I run mysqld ? I've tried everything , the PC loads something , then is ready to continue - there is no mysqld.exe running in the Task Manager

The traffic light remains red - I dont understand this at all :( I can usually bring up a server no problem at all

<Edit>

Here is my "log" of what cmd shows

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Meh>cd \mySQL\bin

C:\mySQL\bin>winmysqladmin

<winmysqladmin loads up  - red traffic light. I click start this service. The traffic light flashes green! Then turns to red.>


C:\mySQL\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\mySQL\bin>I_HATE_mySQL_I_WANT_IT TO DIE!!
'I_HATE_mySQL_I_WANT_IT_TO_DIE!!' is not recognized as an internal or external command,
operable program or batch file.

C:\mySQL\bin>quit

<closes>

[Pyrix]

if you are using an ntbased OS (Win xp , 2k ..) run ./mysql/bin/mysqld-nt.exe , afterward winmysqladmin.exe .
If the trafficlight doesnt turn green its an windows prob ....

[Dave987]

Nope, no matter what I run , winmysqladmin wants to stay red. I remember having this problem once before, I reinstalled mySQL and it worked fine - anyone have any ideas why the Setup won't run?

It says it can't find the file and to check to make sure the path and target name are correct. :evil: (Yes I have extracted it..)

I really want to get this up and running.. thanks for the help so far everyone.

[Edit : I have restarted several times]

[RangerDown]

Check your Event Log, it might be able to give you hints on what's keeping MySQL from starting. To do that bring up a Start->Run dialog and type

compmgmt.msc

Under System Tools on the left hand pane, select Event Viewer.

Look in the System Log for events labeled "Service Control Manager" -- these events will say if a service (like the mysqld service) failed to start and will give a reason why.

[Dave987]

Nope , nothing about mysqld failing , just a bunch of

The MySql service was successfully sent a start control.

The MySql service entered the running state.

The MySql service terminated unexpectedly. It has done this x time(s).

:evil:

[Derision]

This may not help, but from looking around with google, you could try, from a command prompt:

C:\mysql\bin\mysqld --standalone --debug

You should get a debug trace in C:\mysqld.trace which might give you a clue as to what is going wrong ... or maybe not, but might be worth a try.

[Dave987]

Thanks for the help everyone, but unfortunately nothing seems to work. I'll just help run a server until I format my hard drive ..

Thanks again everone - life's a bitch (

(Wow.. I need a life!)