[Guide] FIX "Client does not support authentication" on LOGIN SERVER

[DaRKav]

I'm sure some of you faced the error below on LOGIN SERVER:

Anyone has any ideas about that? 
I tried everything... MySQL 5.1, 5.0 and 4.1

thread 1 : connect login db failed
ERROR: SQL = [mysql_real_connect]
       ERR = [Client does not support authentication protocol requested by server; consider upgrading MySQL client]
thread 2 : connect login db failed
ERROR: SQL = [mysql_real_connect]
       ERR = [Client does not support authentication protocol requested by server; consider upgrading MySQL client]
thread 0 : connect login db failed
ERROR: SQL = [mysql_real_connect]
       ERR = [Client does not support authentication protocol requested by server; consider upgrading MySQL client]
thread 1 : connect login db failed

Here is how you solve it step by step.
1. Go to login server directory and rename original libmySQL.dll to libmySQL.dll.bak
2. Go to MySql BIN directory (Usually C:\Program Files\MySQL\MySQL Server 4.1\bin)
3. Copy libmySQL.dll from MySQL BIN directory to your login server directory.
4. Open Login_Server.ini file with notepad
5. Go to connect Database section and make sure it looks like this:

[connectDatabase]
Name = "Database"
BindIP = "localhost"
BindPort = 0
ConnectPort = 3309
Type = 1
database = "account"
username = "root"
password = "root"
sendQueueCapacity = 3000
recvQueueCapacity = 3000
ConnectIP = "localhost"
ConnectPort = 3309

Change 3309 to your MySQL port and notice that there is two lines of ConnectPort settings, i donno why two 'same' lines are there but i simply kept it there just in case (one of the lines by default was set to '0')

Now, launch the login server, WORKS!?! It should! :D

[MentaL]

[DevilOwn]

bump>

[DevilOwn]

Boring

[Huskyhond]

hmm thank you i wil ltry it

[recca421]

What version of the server are these changes for? I only had to copypasta the DLL for the 1.5x server. All ports were set correctly in the config files on that version.

I've been working a lot as of late, and I've been slipping on my translation project. I hope to get it going again at some point, although I will be basing my translation oin the v1.5x client/server pairing.

Cheers,
[RECCA]

[juliom]

thanks for info.

[SFisLjR]

halo, delivers you the best http://sourceradix.com/m/f277.html

[bLoWoNeR]

i will be try Nice work!