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?

[eq4me]

Most probably you should start the MySQL server.

[Angelox]

Originally Posted by 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?

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 [IMG] for that,



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, [img]image link here[/img]

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]

Originally Posted by deranged

Ok well, Angel your answer is I used the image codes, [img]image link here[/img]

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]

Originally Posted by eq4me

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...=ws70845mysql5

Version: 5.0.24a

I installed it in C:\

[Angelox]

Originally Posted by deranged

I got MySQL from this guide http://www.eqemulator.net/wiki/wikka...=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...indowsServer70

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/...eshooting.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*)