EQEmulator Forums - MYSQL error #1405 #2001: Rejected Password

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - MYSQL error #1405 #2001: Rejected Password (https://www.eqemulator.org/forums/showthread.php?t=13860)

MYSQL error #1405 #2001: Rejected Password

I was setting up a mini-login type server and I found that I have done everything right... I think. However, when I start up world.exe I get the MYSQL error(s) 1405 and 2001 about a rejected password. I have checked time and time again my passwords in the my.ini of MYSQL. Has anyone else had problems such as this? The minilogin.exe works perfect when I start it... but world.exe always gives me this error.

Hello, again!

A link about this error.

Basically, either your user/pass combo is wrong (which you checked) or your user/pass does not have the proper privleges in MySQL. Try the following:

Code:

START->RUN->CMD

cd c:/mysql/bin 

mysql -u root mysql 

GRANT ALL PRIVELEGES ON *.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION; 

quit

~Gandar

Let me know if that clears it up.

You'll probably need to replace the line that reads:

Quote:

cd c:/mysql/bin

with:

Quote:

cd c:\mysql\bin

Windows doesn't handle UNIX/Linux style directories very well. . .

LOL - good catch, Mikenune... I switch constantly between Linux and Windows, so I missed it completely.

<sigh> Sometimes it's the little things that are so easy to miss! :shock:

Quote:

Originally Posted by gandar

LOL - good catch, Mikenune... I switch constantly between Linux and Windows, so I missed it completely.

<sigh> Sometimes it's the little things that are so easy to miss! :shock:

Heh, the only reason I caught it is because I do exactly the same thing!

It's annoying as hell too. I spend 4 hours programming on a Linux box then go home to my Win XP system and wonder when I get an error when I type "ls -la"! :oops:

Of course, I solved that problem by getting myself a copy of the UnxUtils.zip (just search in Google). It just includes Win32 builds of a bunch of common UNIX/Linux commands/programs like "grep" and "ls".

Thanks for the link... I had installed it in the past when I was using Win2k, but when I formatted and switched to WinXP Pro, I forgot to reinstall. :P

Do you know how many times on the command line I type "vi" or "ls" ? Or try to do a "ln" command? :) I definetly understand where you are coming from.

Or, worse yet, type "dir" in Linux?

Lol, thanks for the tip gandar, it seems to be working, with the exception that my computer is so bogged down with stuff it freezes all the time (a pain in the ass).

gandar... I recall in an earlier post you said that you maintained a LAN server for your friends. First of all, was that you or did I make a mistake? If it was you, then I must ask, did you use the Big LAN Book tutorial?

No, Bopo, you're right - I said it! /guilty

I do maintain my own EQEmu server on my LAN. I don't believe I used the Big Lan Book tutorial... but then again, I setup the server almost 3 mos ago and I can't remember... I read a bunch of posts before even attempting it - and even then it took about 4 hours for me to get it running. I tried to answer all my questions before I had them - it didn't really work out that way! :)

I have an AMD 2400, 512mb RAM, 30gb HD, 2mb video card :shock: 10/100 mb NIC running Win2K Pro... It's only job is a MySQL server and it hosts Minilogin, World and Zone. I play across my LAN on my personal machine (lol - better video card)...

I've had up to 15 people logged into my server - both in a single zone and in multiple zones (I usually run with PoK static and 5 dynamic zones since there's usually only about 5 of us and we're grouped). It gets slightly laggy about there, but no one complains (afterall, it's free! :P )

If you have a specific question, I'll be more than happy to try to point you in the right direction or provide an answer if I have it.

~Gandar

Okay, that is neat. I am trying to do that, since I have unsuccessfully tried an online server and a Mini-login (my computer too bogged down). I just wanted to do a LAN server so me and my friends could customize it. If it is too dificult, however, I might have to wait until more into the summer. Thanks for your help, I should hope you can answer some of my other questions.