"Client does not support authentication protocol requested by server; consider upgrading MySQL client (Exception)" about crystal-mysql HOT 7 OPEN

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

from crystal-mysql.

/cc @bcardiff 😅

from crystal-mysql.

@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.

from crystal-mysql.

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 '';

from crystal-mysql.

I have the same issue with MySQL 8.0.13.

from crystal-mysql.

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

from crystal-mysql.

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

from crystal-mysql.