For all those still getting the 1045 do this
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... |
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. |
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..
|
damn nm this is for 1045..hehe I need 1405 =/
|
access died for user: @localhost
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! |
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. |
[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. |
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. |
Mysql
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 |
All times are GMT -4. The time now is 04:34 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.