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.