Ok, question

[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