Access still denied

[The Omega Soldier]

I've tried flushing the database and redoing it, and also using the insert into account command to set an account called eqemu into the database with full privileges, but when i run world.exe i still get access denied errors. Any ideas?

(btw i still can't get grant command to work, no matter how many dif ways i type in i get access denied)

using latest version mysql and world data and eqemu

any help would be greatly appreciated

thanks
the omega soldier

[Mauritius]

aye

can you post the exact error message you get and the content of your .ini and .bat files ?

[Trumpcard]

Access Denied is a mysql access error, nothing to do with accounts.

If the GRANT command doesnt work, the server will never work, it can't get data from the database.

Go to:
www.mysql.com

and look in the mysql documentation for instructions on the GRANT system, it's pretty simple. You're most likely just typing something in incorrectly.

Also, the mysql user has NOTHING to do with any EQEMU logon accounts, it's only used by the world and zone servers for contacting the database.

[The Omega Soldier]

Ok thanks, I guess I will have to just go back to a lower version then I didn't have this problem with 3.23

[eq-chris]

I was never able to get EQemu working with mysql 4, though it runs perfectly on 3.23. Damndest thing.

[Trumpcard]

Thats odd.. I never had any problems with mysql 4.. the GRANT system is supposed to be identical to that in 3.x

[Velosity]

yeah i had the access denied when using MySql 4, yet runs perfectly on 3.23

hmmmm wonder whats up with that

[a_pond_sturgeon]

Mysql 4.x runs fine....I had the same problem you did, searched around, and tried different things, then found the solution....try this, which I have posted on about 3 other topics:


Make sure you have winmysqladim running first.

Then go to start, run, then type in "command" without quotes.

Then type in, without quotes: "c:\mysql\bin\mysql.exe --user=root eq" then press enter.

This should change the promt to mysql, then type as follows without quotes: "GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;"

That should do it, worked for me and others, search around and you'll find exactly what I just privided you with kk thx. Hope this helps, later....

[eq-chris]

I don't remember the problem I had with 4, but it runs fine on 3.23.