EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Tutorials/Howto's (https://www.eqemulator.org/forums/forumdisplay.php?f=619)
-   -   Setting up local EQEMu Server v0.4.4-DR1 (https://www.eqemulator.org/forums/showthread.php?t=6392)

mamba666 06-20-2003 09:55 AM

Error: #1045: Access denied for user
 
Hi,
For this specific error you must do the Grant All Privileges command.
Specifically grant the permission for the user that you use to connect to the MYSQL database.

Here is the command that I used. My username is "mysql" that I access my mysql database with.

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


This eliminated that acess denied error.

When I did the generic command :

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

This did not work for me.


I hope this gets you going.

kertunkulous 06-20-2003 10:46 AM

Here are the files as i have them:

[Database]
host=127.0.0.1
user=something with no spaces
password=something with no spaces
database=eq
compression=off

[LoginServer]
loginserver=127.0.0.1
loginserver2=127.0.0.1
loginport=5999
loginport2=5999
worldname=MyWorld
worldaddress=127.0.0.1
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[Boot5zones.bat]
start zone . 127.0.0.1 7995 127.0.0.1
start zone . 127.0.0.1 7996 127.0.0.1
start zone . 127.0.0.1 7997 127.0.0.1
start zone . 127.0.0.1 7998 127.0.0.1
start zone . 127.0.0.1 7999 127.0.0.1
exit
cls

[MiniLoginAccounts.ini]
localhost something something

[EqHost.txt]
[Registration Servers]
{
"localhost:5999"
}
[Login Servers]
{
"localhost:5999"
}

[datarate.txt]
10.0

i have to type this into mysql to get it to accept the grant:
c:\>mysql.exe --user=root eq
mysql>GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;

and yet, i'm still getting "error #1045 access denied" i found something in the forums about internal addressing, but didn't understand it at all. i can log on and everyting, but "world.exe" just isn't loading or working at all. i've gone through the readme.txt file at least twenty times trying to find a solution. any help would be greatly appreciated.

Bensaret 06-23-2003 04:18 AM

When it says to install all expansions, does it really matter to have all the expansions installed, because I only have all the expansions up to Luclin, i never got plains of power.

Bigpull 06-23-2003 04:38 AM

Quote:

Originally Posted by Bensaret
When it says to install all expansions, does it really matter to have all the expansions installed, because I only have all the expansions up to Luclin, i never got plains of power.

when it says "install all expansions" ir should read "install all of your expansions"

a_Guest03 06-23-2003 05:00 AM

If you don't have the files to go somewhere, don't. But the game will let you go to any zone. You can get trapped there and may need to drag your butt out of there using the database.

Bensaret 06-23-2003 08:23 AM

I did everything the tutorial said, but i can't seem to get world.exe and boot5zones.bat to stay open, they keep closing, however when I go into c:\games\eqemu\eqgame patchme it starts up and I can even type in "eqemu" for the user name and password but I can't find any servers at all in the list, its all empty, plz help.


Also, what exactly am I supposed to see when I type this in, cause I don't think it came out right for me.
"world.exe flag eqemu 200"

tlewis1314 06-23-2003 08:33 AM

Execlent install directions!! I got my server up and running and can login and play! Sweet. Thanks for the great work!

One questions however...

When I create a spell caster I go to the merchants in the guild and .... No Spells :cry: . Is there a database that you recommend sourcing to correct this issue?

Thanks in advance.

Todd

a_Guest03 06-23-2003 08:41 AM

Look in the Worldbuilding forum for Drawde's itemsbooks.zip.

It might be linked in my sig. I don't know if that one works.

Bensaret 06-23-2003 12:11 PM

When I try and start world.exe i get, "Error: #1045 Access denied for user: 'myusername@localhost' <Using password: YES>"

And when I run "boot5zones.bat" several windows open and close so fast i can't see what they say but I know it ain't good. So please someone help me, don't leave me in the cold.

a_Guest03 06-23-2003 04:46 PM

Do the grant command again and BE SURE THAT YOU ARE ROOT!! mysql --user-root or some command like that.

Acolyte 06-23-2003 05:04 PM

mysql -u root -p

Bensaret 06-24-2003 04:11 AM

I don't know what you guys are doing different but I still get error #1045. I tried re-entering the GRANT command like you said and there's no difference. I still can't start up world.exe or boot5zones. Also, when I tried and did "world.exe flag eqemu 200" I get some weird error messages, something about reading the readme.txt. I can login the game using eqemu as the password and user name, but I just don't see any servers in the list

a_Guest03 06-24-2003 04:14 AM

Start a new post in the Win32 Server Support Forum with the steps you take, and where you get your 1045 error.

Bensaret 06-24-2003 05:06 AM

Woohoo! I can now see my server and I can now load world.exe and boot5zones! However, when I try to login to my server, it seems to be loading it, but before it gets to a loading screen it pops up with an EQ message that says this: "Error 1017: Cannot login to the EverQuest server. You may need to re-run the Update Patch. Repeatedly seeing this message indicates a loss of connectivity to the patch server. This is usually temporary." Please tell me I'm not the only one that has this problem, thanks for the help.

a_Guest03 06-24-2003 05:12 AM

Post support questions in support forums.

TheFunkyBox 07-02-2003 12:06 PM

I still cant find the EQbackup00.zip link!

Please help!

Impaler 07-04-2003 10:58 AM

having a prob w/ World.exe flag eqemu 200
 
hello, can't seem to get this to work but i have my directories set up like such. c:\eqemu\eqgame (this is my eqemu game thing i'm trying to set up) and C:\program files\everquest (this is the real thing of everquest) C:\MySQL\bin (such as yall have or yall showed in the Turtorial) and so i go to run in the start menu get to the C prompt and i type

C:\>cd c:\eqemu ----and i hit enter on this and it takes me to

C:\EQEMU>--at this point i'm suppose to type in world.exe flag eqemu 200 right? i did that and got this.

C:\EQEMU>world.exe flag eqemu 200
failed to connect to database: Error: #1045: Access denied for user: 'Mysql_user@localhost' <Using Password: yes>
[status] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4-DR1
Account being GM Flagged:eqemu, Level: 200
Database Error: Lost Connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
database.setGMFlag failed.

:'( oh well was just wondering if there was anything i could to fix this...
-- oh and btw Dev's... i'm sorry for posting that post in the wrong section u locked it down :( was bad boy i guess... sorry just thought i'd let ya know i was sorry --
Best Regards
Christopher

Impaler 07-04-2003 11:19 AM

HAHAHA :D
 
hehe... i fixed it... obviously my Spacebar was messed up... did two spaces after the eqemu part to the 200 so it looked like this
world.exe flag eqemu 200 .... hehe shoulda looked like this
world.exe flag eqemu 200 ... just the little bit of difference there made it not work right... so try to double check yourself's like i shoulda did :) sorry for the waste of space.
best regards
Christopher Morton

a_Guest03 07-04-2003 11:58 AM

Double space bar doesn't show up, but I get the idea.

IAazzwip 07-20-2003 09:17 PM

after installing mysql
 
this is something that is posted several other places, however after messing around with it for the better part of 12 hours or so and nearly smashing my computer and reading as much as i could take on the documetation of mysql from the makers- :? i found that getting permissions for mysql using version 3.23.57 is accomplished simply by hitting Start (on the toolbar) opening a dos prompt and type:

c:\mysql\bin\mysql -u root -p

when the password entry shows up- hit enter because there isnt one yet.

go on with the permission granting as usual from the above posts- but with an initial install with windows this is the default all permissions user-

hope it helps

Tizzard 07-21-2003 08:55 PM

Devlor... you need to post your Database again.. There is no link for it attached anywhere. I think people are getting stuck there as did I for a while.


All times are GMT -4. The time now is 03:24 PM.

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