SUMMARY
`caching_sha2_password.so` cannot be found for digikam in macos
when connecting to a MySQL 8.4.3 server

STEPS TO REPRODUCE
1. install digikam
2. try connect to a remote MySQL 8 instance

OBSERVED RESULT
```
Database connection test was not successful. 
Error was: Plugin caching_sha2_password could not be loaded: dlopen(/opt/digikam.org.arm64/lib/mariadb-10.11/plugin/caching_sha2_password.so, 0x0002): tried: '/opt/digikam.org.arm64/lib/mariadb-10.11/plugin/caching_sha2_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/opt/digikam.org.arm64/lib/mariadb-10.11/plugin/caching_sha2_password.so' (no such file), '/opt/digikam.org.arm64/lib/mariadb-10.11/plugin/caching_sha2_password.so' (no such file) QMYSQL: Unable to connect
```

EXPECTED RESULT
successfully connected

SOFTWARE/OS VERSIONS
macOS: 15.13 arm64

ADDITIONAL INFORMATION
For the balance of efficiency and data disaster recovery, i'm using a SaaS remote mysql, hence i cannot change the configuration of the mysql server. therefore change the default_authentication_plugin to mysql_native_password cannot be achived

There was a issue [478375](https://bugs.kde.org/show_bug.cgi?id=478375) for the internal mysql server