EQEmulator Forums - mySQL - open, beep, close

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - mySQL - open, beep, close (https://www.eqemulator.org/forums/showthread.php?t=14141)

Dave987

06-06-2004 12:48 AM

mySQL - open, beep, close

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

06-06-2004 02:54 AM

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

Dave987

06-06-2004 03:03 AM

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

Quote:

Code:

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



&lt;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



&lt;closes>

Pyrix

06-06-2004 04:34 AM

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

06-06-2004 04:42 AM

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

06-06-2004 05:27 AM

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

Code:

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

06-06-2004 05:35 AM

Nope , nothing about mysqld failing , just a bunch of

Quote:

The MySql service was successfully sent a start control.

Quote:

The MySql service entered the running state.

Quote:

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

:evil:

Derision

06-07-2004 08:57 AM

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

06-09-2004 06:30 AM

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

Thanks again everone - life's a bitch :wink: (

(Wow.. I need a life!)

All times are GMT -4. The time now is 01:49 AM.