World.exe closes instantly...

[zigmoon]

I've got MYSQL running in the background, I just got to the part where I need to run it, in server setup, but every time I double click on it, it closes itself down almost instantly, before I can read the text. Any help?

I'm running Windows 2000.

[dagibbet]

2 things. first you can try running world.exe from the command prompt to see the error your getting, which is more than likely telling you that it cant find the db.ini file. Second, move the world.exe and zone.exe into the EQEMu Release directory and run them from there.

[dagibbet]

2 things. first you can try running world.exe from the command prompt to see the error your getting, which is more than likely telling you that it cant find the db.ini file. Second, move the world.exe and zone.exe into the EQEMu Release directory and run them from there.

[zigmoon]

Stupid me, must not have been thinking. I'll try that, thanks.

[zigmoon]

Hmm, I got that working somewhat, but now it says the Username/Password aren't right, even though they are exactly what I put in....

[rmm99]

You can't use a blank password. If that field is blank in the ini it causes exactly what you are seeing.

[zigmoon]

It isn't I used my normal password for everything.

[rmm99]

Sorry, what i posted is in regards to the window poofing. Missed your post regarding it was working but you get invalid user/pass.

I followed the guide for mine, and when I told winmysqladmin to make the password, it was still blank in mysql, which I found out by doing (from a command prompt in c:\mysql\bin) :

mysql -u username -p

The password was blank, not what I set it to. So I created a new user in mysql by doing

GRANT ALL PRIVILEGES ON *.* TO username@'%'
    ->     IDENTIFIED BY 'somepassword' WITH GRANT OPTION;

This created a new user called username with a password of somepassword which I then put in the ini file and it worked. You'll want to read up on the mysql documentation, because granting every db permission (drop, create, alter) isn't probably a good idea, but it did give me a working server with which i could then modify the privileges back down. I guess I could have delved further and corrected the password on the original account, but last time I messed with a mysql password on my linux box I hosed it hah. Anyway, hope that's your problem too, if not, sorry - tried =b

[zigmoon]

Still isn't working. It keeps saying I don't have permission to change passwords and stuff.

[Trumpcard]

My recommendation is you get some familiarity with mysql's permissions system.


http://www.mysql.com/doc/en/Privilege_system.html

[a_Guest03]

move zig.

[Mongrel]

If you intend to run this as a private server (i.e. no internet connection running while playing on your server) you can also start mysql with the --skip-grant-tables parameter.

Example:
Start -> Run -> "cmd"
c:\
cd\mysql\bin
mysqld-nt.exe --skip-grant-tables

(creating a batch file in mysql/bin directory would be an easier solution)

This will ignore all privileges and allow ANYONE to do whatever he/she wants with your databases (hence the comment about your server being private only).
Skipping the grant tables is somewhat dangerous, however, it will solve your problem with the wrong username/password.

Edit: typo

[zigmoon]

Mongrel, that stopped that error, thanks a bunch.

Edit: Removed, because I fixed it by adding a space.

[zigmoon]

Now I'm having trouble with zone.exe, it's acting as though I didn't put in the addresses.