Issues with MySQL, world.exe, and boot5zones.bat...

[Maranwe]

Not sure if this is the right place to post this or not but I'm having a really wierd issue with MySQL not allowing connections using the username and password I specified for my.ini...

It seems to allow MySQL-Front to connect using teh username "root" and no password, but it won't let me connect otherwise. I'm using version 4 of MySQL, in case that makes a difference.

Also, when I try to run world.exe and boot5zones.bat from the eqemu directory, they flash up and then disappear. Should I be running them from a command prompt instead?

Running WindowsXP Home.

Maranwe

[Maranwe]

OK, I ran world.exe from within a command line window and it gave me the following error (which was followed by still other errors resulting from teh problem reported in teh first one):

Failed to connect to database: Error: #1045: Access denied for user: 'MySQLUserID@127.0.0.1' <Using password: YES>

Where "MySQLUserID is actually the username I specified in both my SQL my.ini file and in my db.ini file.

Do I have to run world.exe as a SYSTEM process rather than a user process in order for it to properly connect to the database or is something else up?

I haven't searched for this error on teh boards yet so I'm going to do that now.

Maranwe

[Maranwe]

OK, read the thread here and tried to use the information there to use the GRANT command in mysql.exe which I had tried to do before and couldn't seem to get it right...

Using the following command (with username and password as ###), I got a new error:

GRANT ALL PRIVILEGES ON eq.* TO ###@127.0.0.1 IDENTIFIED BY '###' WITH GRANT OPTION;

Press enter and get the following error:

Error 1044: Access denied for user '@127.0.0.1' to database 'eq'


OK, so now what?

I'm trying to connect to MiniLogin

Following are my files' data:


db.ini
[Database]
host=127.0.0.1
user=###
password=###
database=eq
compression=off


loginserver.ini
[LoginServer]
loginserver=localhost
loginserver2=localhost
loginport=5999
loginport2=5999
worldname=The Shadow Dragon's
worldaddress=localhost
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=


eqhost.txt
[Registration Servers]
{
"localhost:5999"
}
[Login Servers]
{
"localhost:5999"
}


I'm trying to connect to MiniLogin on a Windows XP Home system

help please :cry:

[Maranwe]

OK, search tool for the boards is a god-send I got it working, now I can finally see about playing around with world building stuff. Thanks for all the help that you all gave me before I even asked for it, I just had to find it

Maranwe

[Maranwe]

For the record, on Windows XP Home running MySQL 4.0 you MUST run mysql.exe from a command line window and you MUST include the "--user=root eq" parameters in teh command to execute mysql.exe from teh command line in order to get the GRANT commands to work properly.

Also, it seems that on Windows XP HOME you MUST run world.exe and boot5zones.bat from within a command line window as well or they disappear once they stop proccessing (i.e. when the shut down because of an error, etc.)

Maranwe