EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=616)
-   -   help with world.exe (https://www.eqemulator.org/forums/showthread.php?t=7096)

notengolegs37 05-07-2003 08:11 AM

help with world.exe
 
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 05-10-2003 05:42 PM

no clue i got the same prob

mrclose 05-18-2003 02:17 AM

Possibility
 
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 05-18-2003 02:37 AM

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 05-24-2003 09:27 PM

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

Raex_The_Overlord 05-28-2003 12:13 PM

Quote:

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 05-28-2003 03:58 PM

here.
 
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 05-28-2003 08:01 PM

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 05-29-2003 01:03 PM

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 05-29-2003 01:26 PM

select * from user;

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

Raex_The_Overlord 05-29-2003 02:00 PM

select eq.* from Joe;


I got error 1051

danipunk 06-17-2003 05:40 AM

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 06-17-2003 05:48 AM

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 06-20-2003 06:27 AM

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.


All times are GMT -4. The time now is 08:44 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.