EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   For all those still getting the 1045 do this (https://www.eqemulator.org/forums/showthread.php?t=8526)

dandyandy70 07-04-2003 10:03 AM

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...

drago1112 08-01-2003 07:41 PM

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

08-11-2003 09:36 AM

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 08-12-2003 07:58 AM

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 08-12-2003 07:59 AM

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

DerekTG86 08-21-2003 09:44 AM

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!

Merth 08-21-2003 10:00 AM

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 08-21-2003 07:03 PM

[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 08-21-2003 07:08 PM

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 08-25-2003 06:27 AM

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.