PDA

View Full Version : Error 2006?!?!?!?


VooodooKiller28
04-12-2004, 03:35 PM
So ive looked at all the posts to resolve the error 2006
But they rnt workin so i come to ask for help
I opened up the Mysqladmin and in the my.ini setup it says my username and password but wen i start it it gives me 2006 error and then i opend up Mysql.exe and put the command

GRANT ALL PRIVILEGES ON eq.* TO someid@localhost
IDENTIFIED BY 'somepass' WITH GRANT OPTION;

and inserted my username in with someid and my pass for somepass
But it says access denied for user: 'localhost'. . .
And also tried

grant all privileges on *.* to username@localhost identified by 'password' with grant option;

But its access denied for that one too. . .

Can neone help me????

Thx 8)

VooodooKiller28
04-12-2004, 04:23 PM
O and i tried that one with the % in place of the username and password but that didnt work either cuz access denied :( plz help me

VooodooKiller28
04-12-2004, 04:25 PM
Lol i sounded like a lil sad puppy plz help me lol
Im not a sad lil puppy i just reeeeaaalllly want to get the server up
:lol:

gandar
04-12-2004, 04:28 PM
Try this:
At the command prompt: (START->RUN->CMD)
cd\mysql\bin
mysql -u root mysql

grant all privileges on eq.* to username@localhost identified by 'password' with grant option;


(replace username/password with your winmysqladmin username//password).

I used the following (also several others :P ) link to setup my server: http://www.eqemulator.net/forums/viewtopic.php?t=13403&highlight=sql+server+setup
(http://www.eqemulator.net/forums/viewtopic.php?t=13403&highlight=sql+server+setup)

I hope this helps!