View Single Post
  #3  
Old 01-21-2004, 12:58 PM
nuke_m_good2
Fire Beetle
 
Join Date: Jan 2004
Posts: 4
Default 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
Reply With Quote