Would this be what you mean?
INSERT INTO account SET name='eqemu', password='eqemu', status=200;
Where 'eqemu' is my account / pass?
I inserted this by doing the standard
use eq;
INSERT INTO account SET name='eqemu', password='eqemu', status=200;
It did it, and then i tried using world.exe and got the same screen / errors as my first post. when i tried using the
world adduser eqemu eqemu 200 -- i got this instead. Says mysql has "gone away" again.
C:\EqEmu>world adduser eqemu eqemu 200
Got signal 0
[Status] CURRENT_WORLD_VERSION:EQEMu 0.5.2
Account Attempting to be created:eqemu 200
Database Error: Lost connection, attempting to recover....
DB Query Error #2006: MySQL server has gone away
Error in CreateAccount query 'INSERT INTO account SET name='eqemu', password='eq
emu', status=200, lsaccount_id=0;' #2006: MySQL server has gone away
database.CreateAccount failed.
I tried doing the Grant all access as posted in the sticky, here's what happened:
mysql> use eq;
Database changed
mysql> GRANT ALL PRIVILEGES ON eq.* TO someid@"%"
-> IDENTIFIED BY 'somepass' WITH GRANT OPTION;
ERROR 1044: Access denied for user: '@localhost' to database 'eq'
I'm getting sorta confused about now :(
- Nuke
|