blackbeam/mysql_async

mysql_native_password or caching_sha2_password

adrianboston opened this issue · 3 comments

adrianboston commented

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

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

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

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