Error has me lost...

[deranged]

Hey all, I just started not to long ago wanting to make a server and I ran into this error getting ready to create my database and loading the sql files, but unfortunately I cant do that because this error stopped me, anyone happen to know how to fix it?

http://img204.imageshack.us/img204/7193/erroran5.th.jpg (http://img204.imageshack.us/my.php?image=erroran5.jpg)

[eq4me]

Most probably you should start the MySQL server.

[Angelox]

Hey all, I just started not to long ago wanting to make a server and I ran into this error getting ready to create my database and loading the sql files, but unfortunately I cant do that because this error stopped me, anyone happen to know how to fix it?

http://img204.imageshack.us/img204/7193/erroran5.th.jpg (http://img204.imageshack.us/my.php?image=erroran5.jpg)

I got a question for you;
How the HELL did you post an image , when I can't?

Anyways, looks like you don't have the proper setting in your eqemu ini files - can you post them?

[eq4me]

Oh,

this is simple use for that,

[IMG]http://www.eqemulator.net/head_03_nb.jpg

But I must disagree about the eqemu ini file. He tried to connect with the mysql client binary in the screenshot

[deranged]

Ok well, Angel your answer is I used the image codes, image link here

What specific inis would you like me to show you? I havent touched anything really, just installed stuff to this step in the latest guide.

EDIT: Oh and when you say start mysql, could you tell me how I can make sure it is on?

"Lets begin detailed Database stuff

Open cmd. Type cd\ (So your at c:\ or whatever root) and then type

[Angelox]

Ok well, Angel your answer is I used the image codes, image link here
Well, for some reason it won't work for me - can you post avatar also?

What specific inis would you like me to show you? I havent touched anything really, just installed stuff to this step in the latest guide.
Could you post your eqemu.config.xml file? It's in your c:\eqemu dir if your using windows

[Angelox]

But I must disagree about the eqemu ini file. He tried to connect with the mysql client binary in the screenshot
I see, I thought I was looking at something else when I saw the pic he posted - Seems like MySql is not properly installed? You should be able to draw up a sql command window from anywhere.
How did you install MySql? what version?

[deranged]

Well if you mean avatar next to your name, im not sure you can do that here, and I havent gotten to the EQemu step yet, im at the mysql database setup right before the EQemu files.

So I dont have any EQemu files till I get this database set up and find out why I am having this problem with my SQL server.

[deranged]

I got MySQL from this guide http://www.eqemulator.net/wiki/wikka.php?wakka=ws70845mysql5

Version: 5.0.24a

I installed it in C:\

[Angelox]

I got MySQL from this guide http://www.eqemulator.net/wiki/wikka.php?wakka=ws70845mysql5

Version: 5.0.24a

I installed it in C:\

If I were you , I wouldn't mess with MySql5 - thats another "hobby" you don't need to get into for now.
Go here;
http://dev.mysql.com/downloads/
and get the MySql 4.1 they have posted. Later, when you feel "daring", try MySql5x if you like. I still don't feel any need for MySql 5, as my version 4 works fine and that's what the Devs here recommend and use.
Do a full uninstall of MySql 5, reboot, then install MySql 4.
Hopefully, it will work as it should.

Also
Do you have an altered "HOSTS" file?

[ndnet]

From the picture, it just looks like the SQL server isn't started. ~.~

Try "NET START MYSQL" at the commandline first. Or, if you did not install as a system service, find mysqld.exe and run it, I believe, maybe mysqld-nt.exe.

I might have service names or exe's wrong, if anyone would care to correct me.

[Angelox]

Here's the link I used to install my Eqemu when I first started out;

http://www.eqemulator.net/wiki/wikka.php?wakka=WindowsServer70

worked fine and I had it all running pretty easy.

[deranged]

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

C:\Documents and Settings\Kelby>cd\
Now this is what I got...


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

C:\>NET START MYSQL
The MySQL service is starting.
The MySQL service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.


C:\>

[John Adams]

http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooting.html

[abaddon]

ok this is a shot in the dark here, but I used to get that error if my My.ini wasnt in the windows root folder... did you do that?

hmm I wish I could recall what causes the 1067 I believe that was it, but ... well I cant recall (I used to have the error constantly, then once I got the damn thing to work correctly I did an .ACE of the installed folder and thats what I use to reinstall now *lol*)

[Magefeu]

I had the same mistake...

This problem occurs when you have or had another version of mysql installed.
Normaly you should be able to launch the winmysqladmin. Doesn't matter if it turns red...
Then right click on the traffic light and select "Remove the service"
Once it's done uninstall all your mysql stuff... reboot and reinstall it...

This should work...

If not just run regedit and delete every single key refering to mysql...

Delete the mysql directory and reinstall