MySQL Plugin caching_sha2_password could not be loaded

English Applications
1

When trying to connect to a MySQL 8.0.16 database where the user is using SHA256 Authentication I receive the following error in both CLI and MySQL Workbench.


ERROR 1045 (28000): Plugin caching_sha2_password could not be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

Upon investigation is seems to be because we are using MariaDB “under the hood”.


$ mysql --version
mysql  Ver 15.1 Distrib 10.8.3-MariaDB, for Linux (x86_64) using  EditLine wrapper

It appears that libmysqlclient provided by MariaDB does not support SHA256 Authentication.

I can connect fine using DBeaver CE (installed via Flatpak), however my work requires some features from Workbench, so I do need to use that from time-to-time.

In the interim I have set the user back to using mysql_native_password but this is not the ideal scenario.
Any thoughts or suggestions on how to move forward with this?

Thanks.

2

Yes, because the “open” in openSUSE.

And yes, I read the same as you: SHA256 Authentication is not supported by MariaDB.

To me, using MariaDB only rather minimal, it looks that you either have to be satisfied with what it delivers, or try to find out how can procure the non opensource MySQL on the system.

3

There is a simple introduction to MariaDB Authentication at https://bradlug.co.uk/blog/2021/04/17/april-13-2021-wireshark-adb-cordova-mariadb

4

Thanks for the feedback.

I guess I’m going to have to stick with using mysql_native_password for the time being.

5

We’re not using MariaDB, it’s just the client libs on tumbleweed causing the issue. Other devs are using *buntu systems and have no issue. I have no desire to use one of those distros.