Error 1044, and other joys

[chanmore]

Hiyas,

Been looking through the other posts first and have tried to fix up the access using "GRANT ALL PRIVILEGES TO chanmore@*.*.*.* IDENTIFIED BY '*******' WITH GRANT OPTION;

With the appropriate IP / PWD in the masked sections.

My response is, ERROR 1044: Access denied for user: '@127.0.0.1' to database 'eq'

----
For a bit more clarification. I've been playing with this for several hours, I've tried using localhost / 127.0.0.1 as well as using my IP. Pretty much the same results... DB.ini and stuff attatched below, as they are at present. Also including the results I get from trying to run world.exe

----
boot5zones.bat

start zone . 203.221.67.246 7995 203.221.67.246
start zone . 203.221.67.246 7996 203.221.67.246
start zone . 203.221.67.246 7997 203.221.67.246
start zone . 203.221.67.246 7998 203.221.67.246
start zone . 203.221.67.246 7999 203.221.67.246

----
db.ini

[Database]
host=localhost
user=chanmore
password=*******
database=eq
compression=off

---
<--Also tried using 127.0.0.1 ->
---

loginserver.ini

[LoginServer]
loginserver=eqlogin1.eqemu.net
loginserver2=eqlogin2.eqemu.net
loginport=5999
loginport2=5999
worldname=Chanmore's
worldaddress=203.221.67.246
locked=false
account=
password=

[WorldServer]
Defaultstatus=
Unavailzone=

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

---

And last but not least, the results I'm getting when trying to run world.exe when things are setup like this =)

---

D:\eqemu>world
Failed to connect to database: Error: #1045: Access denied for user: 'chanmore@127.0.0.1' (Using password: YES)
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.3
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.3
Loading Variables, zone names & items...
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM variables where unix_timestamp(TS) >= 0' #2006: MySQL server has gone away
DB Query Error #2006: MySQL server has gone away
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #2006: MySQL server has gone away
LoadEmuShareMemDLL::Load() failed error=120
Error: Could not load item data

----

Anyone able to give me a miracle cure, or at least what more information I can give? =) Thanks

[a_Guest03]

Please post your mysql version - your mysql server is having some problem. I don't think this particular error is caused by your configs.

[chanmore]

Ok small update:

Followed some information I'd managed to overlook before (Thanks Kalen), I'm now geting a bit futher..

---

Using database 'eq' at localhost
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.3
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.3
Loading Variables, zone names & items...
LoadEMuShareMemDLL::Load() failed error=120
Error: could not load item data

--

At which point world.exe dies once more.

[[Edit: Currently using MySQLAdmin ver 1.4 - Only downloaded mysql from the link on the guide here yesterday, so that shouldn't be an issue. I believe it was the security permissions that were my initial problem.]]

[a_Guest03]

items missing? Try loading up the items from a database like Drawde's. You might have to load some of his older work if you're not doing cvs. I'm not sure. Look for his itemsbooks.zip .

[chanmore]

*MySQL-Newbie* =)

What should I be doing to fire em up? I've got Drawde's book.sql and items.sql in mysql bin... What from there?
| use eq
| source items.sql

?

Fish outa water here to be honest, but gotta start somewhere

[a_Guest03]

I think that's it.

[Torakk99]

well 1044 is kicking my butt so far, I have been reading alot about it and am now trying to give myself more permissions, or change my security permissions, but so far I get the access denied 1044 when trying to grant all options.

If anyone has any info on this topic please post, also would help to know how to give myself more security permisions lol and maybe we can make this a sticky post for future users, this seems to be a stump in the road for alot of people


Merrywine the Great Took

[Fyrre]

BUMP

I'm having the same problems. I downloaded the 4.4 dr 1 database, sourced all the .sql files with mysql.exe, and everything worked fine. I loaded up world.exe, and I got error 1045 access denied and error 1026 mysql server has gone away... I tried to grant all privileges and all I get is error 1044 access denied to user... PLEASE provide an answer to this problem someone.

[Fyrre]

oh yeah, I'm using mysql version 4.0.12.. I get the same problems with 4.0.13 as well.

[Fyrre]

I found a topic containing the information I need to fix the 1044 error when using grant all privileges.. go to a new command prompt, navigate to mysql\bin, then enter mysql.exe --user=root eq. After typing this in, use the grant all privilege command and it should work.