Ok, question

[Balkon]

should I set all the places that ask for ports to 5999 or 3306? If not one, which ones need to be set to 5999 and which ones 3306? Also for IP addresses, which ones should be set to localhost and which ones 127.0.0.1?
Thanks

[Angelox]

You mean your firewall? is this a windows, linux, or router firewall? If you have a router, you don't need Windows or Linux firewall, unless you have a DMZ server.
heres some ports;
3306/udp 5999/udp 9000/udp 7000 - 7005/udp 3306/tcp 5999/tcp 7000 - 7005/tcp
You don't need to clear ports on your router if you play in your LAN only

If you use static zones, then you have to open more of the 7000 ish zones

[Balkon]

No I mean in the files like LoginServer.txt and eqemu_config.xml. I have my firewall turned off, and all those ports enabled. Im not for sure what static zones are, the only experience with this that I've had is the tutorial I went through. I'musing mini login and right now all I'm trying to do is get the server up, no public or even lan, just trying to get singplayer working and lan later.

[techguy84]

What guide did you follow.

If used the latest guide, the GRANT ALL PRIVILAGES command is not needed.


Try this one, as the error you get is normally do to this step being missed in the guide.

set password for 'root'@'localhost' = OLD_PASSWORD('****');

**** being the password for your root account you put in when running the instance server config wizard from the end of the mysql setup. (LEAVE THE ' IN THERE)


To get to where you need to type this in, Start->Programs->Mysql->Mysql Server5->MySql Command Line client

or Go to run, type in cmd, and when that comes up, type in mysql -u root -p



You dont have to be under any database to do this. Just run the command

[Balkon]

I did that step, the ***** is my password. (just blanked it out because it doesnt need to be shown) Thanks for the post, got any other ideas? Does MYSQL need to be in a certain location of my computer? like C:\MYSQL because mine was originally installed in C:\program files\MYSQL

[techguy84]

Not really. I use MySQL in its deafult folder. What version are you running of the emu and mysql. Assuming the latest right?

[05.03. - 18:40:33] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

Are you using eq in your eqemu_config.xml file under the database information, or root


Also, the port number in your eqemu_config.xml file is supposed to be 3306, you have 3309 from a ealier post

[Balkon]

Originally Posted by techguy84

Not really. I use MySQL in its deafult folder. What version are you running of the emu and mysql. Assuming the latest right?



Are you using eq in your eqemu_config.xml file under the database information, or root


Also, the port number in your eqemu_config.xml file is supposed to be 3306, you have 3309 from a ealier post

Yes, both the latest versions in the latest Server setup tutorial for windows. I followed every letter of it as best I could.

What do you mean by "Are you using eq in your eqemu_config.xml file under the database information, or root"? Im not for sure what you ment, my eqemu_config.xml file is in my EQEmu folder and I have it set to root and PEQ database.

Yeah I noticed that and changed the port, still the same problem, so that wasnt it. Thanks alot for the help, I hope you can help me get this working!