[Bug 252420] 'caching_sha2_password' support missing in PHP port, limits MySQL 8 compatibility

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=252420

--- Comment #6 from Markus Kohlmeyer <rootservice at gmail.com> ---
According to PHP Bugtrcker all known related bugs should be fixed since 7.4.2
(Feb 2020):

https://bugs.php.net/bug.php?id=79011
https://bugs.php.net/bug.php?id=76243
https://bugs.php.net/bug.php?id=78981

So even mysqlnd should be able to use caching_sha2_password since 7.4.2.


I suggested using the native mysqllib as opposed to mysqlnd, as mysqllib comes
directly from MySQL and does not have nor had the PHP bugs.
And when mysqllib fails, then every other MySQL-Client inclusive MySQLs own one
fails and any related bug would be fixed asap by Oracle.
It's always better to use an original than an imitation...



To answer your question: No, currently i don't have a spare system to test
this, but as i wrote above, Oracle would put such bugs on highest (very first)
priority as it would effect every single installation out there, not only some
crappy third-party client-implementations.



And yes, openssl should be the only (and mandatory) ssl-library to link against
(both PHP and MySQL). openssl from base is enough.

-- 
You are receiving this mail because:
You are the assignee for the bug.