EQEmulator Forums - Access still denied

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - Access still denied (https://www.eqemulator.org/forums/showthread.php?t=7520)

The Omega Soldier

05-28-2003 03:10 PM

Access still denied

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

05-28-2003 07:28 PM

aye

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

Trumpcard

05-28-2003 11:49 PM

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

05-29-2003 07:04 AM

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

05-29-2003 07:32 AM

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

Trumpcard

05-29-2003 07:33 AM

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

Velosity

05-29-2003 05:57 PM

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

05-30-2003 10:17 AM

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:

Quote:

Originally Posted by a_pond_sturgeon

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

05-30-2003 04:07 PM

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

All times are GMT -4. The time now is 02:32 AM.