Omeka Classic 3.2 with MySql 8.4

Omeka Classic Installing and Upgrading
1

Hello,
Can somebody confirm is Omeka Classic 3.2 compatible and working with MySQL 8.4?
Recently our database server got upgraded from Mysql 8.0 to 8.4 and Omeka can not establish database connection. OS is Rocky Linux 10, selinux disabled, mysql native password plugin enabled/disabled no difference.
And
ALTER USER omeka@localhost IDENTIFIED WITH 'mysql_native_password';
or
ALTER USER omeka@localhost IDENTIFIED WITH 'caching_sha2_password';
has no effect.

[20-Nov-2025 15:13:29 Europe/Dublin] Omeka fatal error: Permission denied. Confirm that the information in your db.ini file is correct.
Login from from command line works with omeka db user and pw.
I’m totally out of ideas.

Thanks!

2

Omeka Classic 3.2 supports PHP 8.4.

“Permission denied” suggests to me something like not having access to the Unix socket used for a localhost connection… does changing the host in the db.ini to 127.0.0.1 instead of localhost do anything? Or, be definitely sure that SELinux is off, as it could certainly cause this kind of symptom.

Edit: and of course, I misread this as “PHP 8.4” not MySQL 8.4. I don’t have direct experience on that front but I’m pretty sure it shouldn’t be a problem (and we haven’t had any reports of issues). The caching_sha2_password thing shouldn’t be an issue with any halfway-recent PHP, and as you said, changing it didn’t matter. I’d still say the same permissions-related things I mentioned above are the most likely issues.

3

Hi,
That did the trick!

;host = “localhost”
host = “127.0.0.1”

However i cant explain it, but it works now!
Thank You!