help with world.exe

[notengolegs37]

I keep getting 1045, in other words access denied. I set up everything to use localhost, yet it says "Access denied for user: 'test@127.0.0.1"

Can anyone help lead me in the correct direction?

[ZakiasTreeClimber]

no clue i got the same prob

[mrclose]

If you are running MySQL version 4 uninstall it and Download a previous version, I believe it is 3.23. I ran into the same problem and that fixed mine.

[Trumpcard]

4.x mysql works fine.

The problem tends to be people not following the 'GRANT ALL PRIVILEGES' section of the howto closely.

From the readme off the main page....
Type in: GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%'; (press enter)
Close out of mysql.exe

[The Omega Soldier]

ok tell me where that section was in the guide and i'll stfu

[Raex_The_Overlord]

4.x mysql works fine.

The problem tends to be people not following the 'GRANT ALL PRIVILEGES' section of the howto closely.

From the readme off the main page....
Type in: GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%'; (press enter)
Close out of mysql.exe

That doesn't work for me...It keeps saying

ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)

So what now Mr.Trumpcard?

[a_pond_sturgeon]

Try this:

Open up the DOS promt, or just go to start, run, then type in "command" without quotes.

(Make sure, you have winmysqladim running)

Then type in- c:\mysql\bin\mysql.exe

Then type in- --user=root eq

Then type in- GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;

That should help, it worked for me, just my 2cp.

[Mauritius]

as you may noticed, there's a difference between
notengolegs37's access denied problem:
Access denied for user: 'test@127.0.0.1
IMHO, either the user specified does not exist, or the password specified is not correct, or the specified user has no rights. Probably it's the last one.

and Raex_The_Overlord's
Access denied for user: '@127.0.0.1' (Using password: NO)
IMHO this should be easier, as there is no username specified.

[Raex_The_Overlord]

GRRRRRRRRR......Ok, lets pretend my Username is Joe and my password is blow......I do the following.

GRANT ALL ON *.* TO 'Joe'@localhost IDENTIFIED BY 'blow' WITH GRANT OPTION;

Still get same error......

[Bigpull]

select * from user;

Odds are you poor mysql auth system is so confused it's not even funny..

[Raex_The_Overlord]

select eq.* from Joe;


I got error 1051

[danipunk]

i got 1045 error if i write this:

GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;

error 1045: acces denied for user: '@localhost' <using password:NO>
and i got 1044 error if i write this other:

GRANT ALL PRIVILEGES ON eq.* TO danipunk@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;

error 1044: acces denied for user: '@localhost' to database 'eq'

[Memener]

make sure your using this verson of mysql
http://www.mysql.com/downloads/mysql-3.23.html
and not the 4.+ i tried use it and i got that same error you can install this without losing your Database
go here and download my add.sql to out in those commands with out having to type them


http://forums.eqemu.net/viewtopic.php?t=8741

[cannonalldex]

omg after all that , this post seems to be heaven sent.

make sure your using this verson of mysql
http://www.mysql.com/downloads/mysql-3.23.html
and not the 4.+ i tried use it and i got that same error you can install this without losing your Database
go here and download my add.sql to out in those commands with out having to type them

i ran everything like im suppose to i think, says im connected to worldserver. i hope this is the gold pot lol.