I'm sure some of you faced the error below on LOGIN SERVER:
Code:
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:
Quote:
[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