[digikam] [Bug 501453] New: Cannot connect to remote MySQL 8

[leo zhen]

https://bugs.kde.org/show_bug.cgi?id=501453

            Bug ID: 501453
           Summary: Cannot connect to remote  MySQL 8
    Classification: Applications
           Product: digikam
           Version: 8.5.0
          Platform: macOS (DMG)
                OS: macOS
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: Database-Mysql
          Assignee: digikam-bugs-null at kde.org
          Reporter: lzhen.dev at outlook.com
  Target Milestone: ---

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

-- 
You are receiving this mail because:
You are watching all bug changes.