connection failure to mysql 8 about crystal-mysql HOT 11 OPEN

default_authentication_plugin with mysql_native_password will be deprecated. sha256_password will be default in the future.

Temporary solution:
CREATE USER 'test'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mypassword';

from crystal-mysql.

I use mysql 8 with --default-authentication-plugin=mysql_native_password and everything seems good

from crystal-mysql.

I have same question
when run
amber db create
output 'packet 254 not implemented'
my amber version 0.11.3
mysql Ver 8.0.12 for osx10.13 on x86_64
Crystal 0.27.2 (2019-02-05)
LLVM: 6.0.1
Default target: x86_64-apple-macosx
crystal-mysql version 0.5.1

from crystal-mysql.

@rdp @clarkyi if you could, please, test my branch, the one I opened the PR and give some feedback if works for you

from crystal-mysql.

Still a thing :( can we fix this?

from crystal-mysql.

Any update about this? Thank you.

from crystal-mysql.

No that I am aware of.

You need to change the authentication plugin to mysql_native_password which is the old default.

The required steps is to implement the handshake of the password according to the caching_sha2_password auth plugin.

References:

• https://github.com/go-sql-driver/mysql/pull/794/files
• https://dev.mysql.com/doc/internals/en/connection-phase-packets.html
• https://dev.mysql.com/doc/dev/mysql-server/latest/page_caching_sha2_authentication_exchanges.html
• https://mariadb.com/kb/en/authentication-plugin-sha-256/
• https://mariadb.org/history-of-mysql-mariadb-authentication-protocols/

Ideally, there should be a way to specify before hand the public key of the server. And not only the on-demand key exchange.

The branch https://github.com/bcardiff/crystal-mysql/tree/sha2_password can help as a starting point.

from crystal-mysql.

Any solution for this yet? I'm seeing this error even after updating the plugin to mysql_native_password.

from crystal-mysql.

from crystal-mysql.

Bump, 4 years and counting

from crystal-mysql.

If you run mysql through homebrew on macos like I do, these are the steps I took to get it working:

1. Open the plist that is used by homebrew start mysql (/usr/local/Cellar/mysql/8.0.31/homebrew.mxcl.mysql.plist was mine)
2. Add <string>--default-authentication-plugin=mysql_native_password</string> to the ProgramArguments array
3. Run brew services restart mysql
4. Start your mysql client mysql -u root -p
5. Change your password ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; (You can change it back after if you'd like)

After all that, it should work as expected.

from crystal-mysql.