Ok, question

[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!

[Angelox]

SET PASSWORD FOR 'eq'@'localhost' = OLD_PASSWORD('newpwd');

If you're using MySql 5x, did you run the above line in your MySql command box?

[Balkon]

Yes I did run that line, even though someone above said I didnt need to, I did anyways.

[techguy84]

I said you didnt need to run the GRANT ALL PRIVILAGES command.

But the one that I mentioned and the one that angelox mentioned have to be run in mysql 5.x. EQEmu was built for mysql 4, and the password system has changed between 4 and 5 so that command is a must.

Mine was for the root account. Angelox mentioned the eq account that you may have created. Given that line I mentioned in my last post about 'eq'@'localhost' error you had in one of your logs, that would mean that in your eqemu_config.xml file under that database information you would have the username as eq instead of root.


ON the contrary though. You posted your xml file that had root in it and also you said that you were using root. So why is this error showing up for you? You have had to change the xml file at some point and put eq in there. If you did this, you need to create the account in mysql, assign it a password.

Then run the GRANT all privilages command from a very early post. This will give 'eq'@'localhost' permision ot accesee and modify the peq databse. You will then also have to run the set password command angelox mentioned to to fix the password scheme from 5.x to make it compatible with 4.x type applications