caching_sha2_password cannot be loaded

[briguyjm]

Error while using the flatpak version on Ubuntu 20.04 and trying to connect to a local MySQL database.

Authentication plugin 'caching_sha2_password' cannot be loaded: /app/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

Flatpak Ver: 1.6.5 Sequeler (flatpak) Ver: 0.7.5 OS: Ubuntu 20.04 LTS

[firrae]

@briguyjm what version of MySQL? I'm running into the same issue with MySQL 8 via Docker.

[briguyjm]

@briguyjm what version of MySQL? I'm running into the same issue with MySQL 8 via Docker.

mysql Ver 8.0.21-0ubuntu0.20.04.4 for Linux on x86_64 ((Ubuntu))

I'm not using Docker or any other VM. MySQL is running on bare metal.

[taozuhong]

Variable	Comment
LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN	Enable mysql_clear_password authentication plugin;
LIBMYSQL_PLUGIN_DIR	Directory in which to look for client plugins.
LIBMYSQL_PLUGINS	Client plugins to preload.

Reference: MySQL environment variables

[briguyjm]

@briguyjm what version of MySQL? I'm running into the same issue with MySQL 8 via Docker.

v8

[bebetoalves]

@briguyjm what version of MySQL? I'm running into the same issue with MySQL 8 via Docker.

This maybe help you.

Authentication plugin 'caching_sha2_password' cannot be loaded

[yoranns]

Are you serious? The solution is revert the mysql auth to a less secure version?

[nodgear]

Lowering the database security is not a valid solution.