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. |
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. |
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.
|
Quote:
|
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.
|
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" |
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 |
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. |
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. |
Do the grant command again and BE SURE THAT YOU ARE ROOT!! mysql --user-root or some command like that.
|
mysql -u root -p
|
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
|
Start a new post in the Win32 Server Support Forum with the steps you take, and where you get your 1045 error.
|
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.
|
Post support questions in support forums.
|
I still cant find the EQbackup00.zip link!
Please help! |
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 |
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 |
Double space bar doesn't show up, but I get the idea.
|
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 |
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.