The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

PHP(wordpress) + auth_ed25519

I am having issues connecting to 10.5 when using 'auth_ed25519'. I have to revert to 'mysql_native_password' to get wordpress to connect, which obv. isn't desirable.

I am using PHP 7.4 which doesn't look like it supports 'auth_ed25519' connections. It does however support 'caching_sha2_password' in 7.4+. However MariaDB doesn't look like it is going to support that at all per MDEV-9804. https://jira.mariadb.org/browse/MDEV-9804

The MariaDB site (https://mariadb.com/kb/en/php/) states that it generally works well with PHP, but at this point, I would say that is outdated. mysql_native_password & SHA1 are a security risk now, what are the plans moving forward to address this?

Answer Answered by Ian Gilfillan in this comment.

You are correct. It's a pity that PHP doesn't support auth_ed25519, and hopefully this will be fixed in future.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.