help with world.exe
I keep getting 1045, in other words access denied. I set up everything to use localhost, yet it says "Access denied for user: 'test@127.0.0.1"
Can anyone help lead me in the correct direction? |
no clue i got the same prob
|
Possibility
If you are running MySQL version 4 uninstall it and Download a previous version, I believe it is 3.23. I ran into the same problem and that fixed mine.
|
4.x mysql works fine.
The problem tends to be people not following the 'GRANT ALL PRIVILEGES' section of the howto closely. From the readme off the main page.... Type in: GRANT ALL PRIVILEGES ON *.* to '%'@localhost IDENTIFIED BY '%'; (press enter) Close out of mysql.exe |
ok tell me where that section was in the guide and i'll stfu
|
Quote:
ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO) So what now Mr.Trumpcard? |
here.
Try this:
Open up the DOS promt, or just go to start, run, then type in "command" without quotes. (Make sure, you have winmysqladim running) Then type in- c:\mysql\bin\mysql.exe Then type in- --user=root eq Then type in- GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION; That should help, it worked for me, just my 2cp. |
as you may noticed, there's a difference between
notengolegs37's access denied problem: Access denied for user: 'test@127.0.0.1 IMHO, either the user specified does not exist, or the password specified is not correct, or the specified user has no rights. Probably it's the last one. and Raex_The_Overlord's Access denied for user: '@127.0.0.1' (Using password: NO) IMHO this should be easier, as there is no username specified. |
GRRRRRRRRR......Ok, lets pretend my Username is Joe and my password is blow......I do the following.
GRANT ALL ON *.* TO 'Joe'@localhost IDENTIFIED BY 'blow' WITH GRANT OPTION; Still get same error...... |
select * from user;
Odds are you poor mysql auth system is so confused it's not even funny.. |
select eq.* from Joe;
I got error 1051 |
i got 1045 error if i write this:
GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION; error 1045: acces denied for user: '@localhost' <using password:NO> and i got 1044 error if i write this other: GRANT ALL PRIVILEGES ON eq.* TO danipunk@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION; error 1044: acces denied for user: '@localhost' to database 'eq' |
make sure your using this verson of mysql
http://www.mysql.com/downloads/mysql-3.23.html and not the 4.+ i tried use it and i got that same error you can install this without losing your Database go here and download my add.sql to out in those commands with out having to type them http://forums.eqemu.net/viewtopic.php?t=8741 |
omg after all that , this post seems to be heaven sent.
make sure your using this verson of mysql http://www.mysql.com/downloads/mysql-3.23.html and not the 4.+ i tried use it and i got that same error you can install this without losing your Database go here and download my add.sql to out in those commands with out having to type them i ran everything like im suppose to i think, says im connected to worldserver. i hope this is the gold pot lol. |
All times are GMT -4. The time now is 08:44 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.