Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[TUT] Fixing "Client does not support authentication protocol "

Realities' Weaver
Joined
Nov 14, 2004
Messages
365
Reaction score
3
Hi,

This is a fix if you are getting this message on your GunBound Server's log:

Code:
Error=Client does not support authentication protocol requested by server; consider upgrading MySQL client
This happens because GunBound server uses an authentication protocol based on a password hashing algorithm that is incompatible with newer versions of MySQL (according to MySQL docs).

So, you have to do this:
  1. Open MySQL Command Line or equivalent;
  2. Use this:
    Code:
    mysql> SET PASSWORD FOR
        -> some_user@some_host = OLD_PASSWORD('newpwd');
  3. Example:
    Code:
    mysql> SET PASSWORD FOR
        -> [B][COLOR=Red]root[/COLOR][/B]@[B][COLOR=Blue]localhost[/COLOR] [/B]= OLD_PASSWORD('[COLOR=Green][B]PretzelWarlord[/B][/COLOR]');
Hope this helps.
 
Last edited:
Newbie Spellweaver
Joined
Sep 30, 2008
Messages
44
Reaction score
0
Re: [Tutorial] Fixing "Client does not support authentication protocol "

haha i remember this one took me a long time to figure out xD
 
Junior Spellweaver
Joined
Oct 24, 2013
Messages
145
Reaction score
8
Re: [Tutorial] Fixing "Client does not support authentication protocol "

where should i put this?

Query or what?



Hi,

This is a fix if you are getting this message on your GunBound Server's log:

Code:
Error=Client does not support authentication protocol requested by server; consider upgrading MySQL client
This happens because GunBound server uses an authentication protocol based on a password hashing algorithm that is incompatible with newer versions of MySQL (according to MySQL docs).

So, you have to do this:
  1. Open MySQL Command Line or equivalent;
  2. Use this:
    Code:
    mysql> SET PASSWORD FOR
        -> some_user@some_host = OLD_PASSWORD('newpwd');
  3. Example:
    Code:
    mysql> SET PASSWORD FOR
        -> [B][COLOR=Red]root[/COLOR][/B]@[B][COLOR=Blue]localhost[/COLOR] [/B]= OLD_PASSWORD('[COLOR=Green][B]PretzelWarlord[/B][/COLOR]');
Hope this helps.


it will be more helpful if make it clear where should you put this... im using xampp and i need this...
:D thank in advance
 
Initiate Mage
Joined
Sep 20, 2009
Messages
1
Reaction score
0
Re: [Tutorial] Fixing "Client does not support authentication protocol "

Then I suggest you create another account in phpMyadmin. But remember to choose password compatible with mySQL ver 4.0
 
Back
Top