View Single Post
  #1  
Old 06-06-2003, 03:57 AM
chanmore
Fire Beetle
 
Join Date: Jun 2003
Location: Australia
Posts: 8
Default Error 1044, and other joys

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
Reply With Quote