search

blackbeam / mysql_async

Asyncronous Rust Mysql driver based on Tokio.
Apache License 2.0
372 stars 113 forks source link

mysql_native_password or caching_sha2_password #281

Closed adrianboston closed 6 months ago

adrianboston commented 6 months ago

More of a question

What auth plugin is this driver using: mysql_native_password aching_sha2_password

I see that the non async mysql offers both along with mysql_clear_password.

I swapped to a different dbms server (with a newer version) and i cannot connect any longer. Tried several things but this seems to stand out. Although a new user was created with the mysql_native_password identification; still failed.

blackbeam commented 6 months ago

Hi. This driver supports mysql_native_password, aching_sha2_password as well as mysql_old_password (if secure_auth is disabled) and mysql_clear_password (if enable_cleartext_plugin is set)

adrianboston commented 6 months ago

Oh nice. I will test caching_sha2_password out. Edited: Yes a user identified by caching_sha2_password does work.

It turned out to be a different issue -- which others may run into.

It seems that the driver cannot connect to the local loopback. Setting the host as either "localhost" or "127.0.0.1" seems to consistently fail.

The resolution was setting bind-address = "0.0.0.0" in mysql conf.

adrianboston commented 6 months ago

I believe this is closed, The resolution was setting bind-address = "0.0.0.0" in mysql conf.