Help with 1142 Error Please
 

If anyone has the time so my head will quit bruising can you please give any advice on this:

Using database 'eq' at 127.0.0.1
[Status] CURRENT_WORLD_VERSION:EQEMu 0.4.4
[Error] CURRENT_WORLD_VERSION:EQEMu 0.4.4
Loading Variables, zone names & items...
Error in LoadVariables query 'SELECT varname, value, unix_timestamp() FROM vari
bles where unix_timestamp(ts) >= 0' #1142: select command denied to user: 'zorl
fe@127.0.0.1' for table 'variables'
Error in LoadZoneNames query 'SELECT MAX(zoneidnumber) FROM zone' #1142: select
command denied to user: 'zorlofe@127.0.0.1' for table 'zone'
EMuShareMem.dll loaded.
Error in GetItemsCount query 'SELECT MAX(id), count(*) FROM items' #1142: selec
command denied to user: 'zorlofe@127.0.0.1' for table 'items'
Error: Database::LoadItems() (sharemem): GetItemsCount() returned -1
Error: Could not load item data. But ignoring
...done.
LoginServer.ini read.
Loading guild ranks...Error in LoadGuilds query 'SELECT id, eqid, name, leader,
minstatus, rank0title, rank1, rank1title, rank2, rank2title, rank3, rank3title,
rank4, rank4title, rank5, rank5title from guilds' #1142: select command denied
o user: 'zorlofe@127.0.0.1' for table 'guilds'
done.
Loading EQ time of day...done.
Deleted -1 stale player corpses from database.
Deleted -1 stale player backups from database.
HELP I WORK IN THE EQEMU SWEATSHOP YOUR MY ONLY HOPE
TCP listening on: localhost:9000
World server listening on: localhost:9000
Error: DBAsyncCB_LoadVariables failed: !GetAnswer: '#1142: select command denie
to user: 'zorlofe@127.0.0.1' for table 'variables''
Error: LoginServer::Connect: 'TCPConnection::Connect(): connect() failed. Error
10061'


Many thanks in advance.....

I figured it out...
 

Well, after days of looking on the web I finally found something to fix this problem so I thought I would share it for other newbies having this problem being I couldn't find info about it on this forum. I realize I may have just missed it but either way. . .
First off I just ran mysql.exe and then loaded my db by typing "use eq" minus the qoutes of course. Then I found this command and put it together to suit my configuration and it looks like this:

GRANT SELECT, INSERT ON eq.* TO zorlofe@localhost;

Hope this may be of some help to somebody down the road. :wink:

I tried didnt work for me im about to kill my self :(

how many?
 

how many different grant commands have you tried? if you havent tried merths you should, worked for me

There is around 20 different way's to do the Grant command listed in these forums. One of them will work for you just look for them and you will find them.