Mysql Connection Error

[GeetaMyra]

Getting following error at the time of testing the mysql connection in redash :

(2059, 'Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory')

[justinclift]

Hmmm, that sounds a lot like the MySQL apt package isn't installed in your Redash setup.

[lucydodo]

You might also find this post helpful, check it out:
https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded