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]

Originally Posted by 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

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.