Error on mysql connect - solved

[carlofab]

I recently upgraded my server to Ubuntu 20.04 (Python 2.7.18, mysql Ver 8.0.23) and I noticed the script was'nt working. After a long troubleshoot I discovered this issue:

mysql_exceptions.OperationalError: (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded

I tested the workaround provided here (https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded) and I suggest to update the readme with this useful command

ALTER USER 'yourusername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'youpassword';

Regards