"Client does not support authentication protocol requested by server; consider upgrading MySQL client (Exception)"

[FredTheHomie]

I get the below error when I try to run the example test code. I am not sure what is causing this. Any help would be greatly appreciated. Just as a note, I have the latest version of MySql.

[faustinoaq]

/cc @bcardiff 😅

[bcardiff]

@FredTheHomie specs are run agains 5.6 and 5.7 only. Probably a bit old if you are running latest version.

Would you mind telling the exact version you are using?
If you like binary protocol, or are willing to, feel free to send a PR implementing part of the protocol that might have changed from the above version to yours.

[rdp]

I ran into this, worked around it by setting a "normal" password for root, FWIW (see comments here: https://dev.mysql.com/doc/refman/5.5/en/old-client.html ). Annnd the comments were all removed. Nice mysql. Anyway fix was ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';

[mamantoha]

I have the same issue with MySQL 8.0.13.

[fernandes]

yeah, it's because the README code initialize without any password for user root, setting a normal user / password, or password for root works flawlessly

[fernandes]

with mysql there's a problem with packet 254, probably related to #62 , trying to figure out

[rdp]

I don't think this was exactly fixed (though a work around was mentioned in the README)...consider reopen'ing?