For all those still getting the 1045 do this

[dandyandy70]

change directory to mysql\bin then run mysql.exe --user=root eq
then do the
GRANT ALL PRIVILEGES ON eq.* to 'yourusername'@127.0.0.1 IDENTIFIED BY 'yourpassword'; do it like that instead of localhost and bingo there you go...

[drago1112]

ok did that and now im getting something else going wrong. i typed in what you said to type in and now im getting the following message.....
ERROR 1044: Access denied for user: '@localhost' to database 'eq'

any suggestions? thanks in advance

dont use the quotes on the username, and if your running windose you dont need the caps(capitol LETTERS). use this

grant all privileges on *.* to eqemu@'%'
identified by 'password' with grant option;

eqemu is my username.
the '%' is another wildcard pointer.
and i believe you can use a wildcard with the password but im not 100% sure.

[trezcan]

Im getting the 1405 error but dont understand how to fix it..I ran the mysql.exe and typed as you did but nothing happened =/ still stuck on last part of the readme file where Im saposed to type in my ip..

[trezcan]

damn nm this is for 1045..hehe I need 1405 =/

[DerekTG86]

I tried what you said I should do.....grant all privileges on *.* to derektg86@'%' identified by 'password';

I still got the same error 1045 access denied for user: '@localhost'

any more suggestions? thanks!

[Merth]

What guide did you follow that led you to the 1045?

Try the guide for setting up a server in the tutorial/howto section. It's a sticky. I have done those steps on 3 different machines now and haven't seen 1045 on any of them.

[n0sn0s]

[Database]
host=192.168.0.3
user=n0s
password=1234
database=eq
compression=off


mysql> GRANT ALL PRIVILEGES ON eq.* TO '%'@localhost IDENTIFIED BY '%' WITH GRAN
T OPTION;
ERROR 1044: Access denied for user: '@localhost' to database 'eq'
mysql> grant all privileges on *.* to n0s@'%' identified by '1234' with grant option;
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
mysql>


Thats what I get, I read the server setup guide on this page to install it and have now redone the directions completely reinstalling both mysql and eqemu with the exact same result about 5 times now.

[Merth]

The sql commands you executed were not in the guide I pointed out above, so you must be following some other guide. Here's the direct url to the guide I was referring to above: http://www.eqemulator.net/forums/viewtopic.php?t=9648.

Try not to skip steps. I've noticed some support threads where the user skipped over an important step, and was asking for support on why another step was failing.

[IAL05T50UL]

hit start button
goto run
mysql.exe -u root

but find your mysql.exe program and place the -u root and you should be able to grant and run other commands. I got this following another forum on how to run a server can't remember whichone since i've taken so much info from different guides and finally got past that error.

heh disregard this post i see you pointed to the right place to run this error out