[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

            Bug ID: 252420
           Summary: 'caching_sha2_password' support missing in PHP port,
                    limits MySQL 8 compatibility
           Product: Ports & Packages
           Version: Latest
          Hardware: amd64
                OS: Any
            Status: New
          Severity: Affects Many People
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs at FreeBSD.org
          Reporter: sean at rogue-research.com

Repro:
- install vanilla FreeBSD 12.2-p2 on 64 bit Intel
- install PHP 7.4.13 from ports/packages
- install MySQL 8.0.22 from ports/packages
- install Apache 2.4.46
- set up basic website with PHP
- create typical phpinfo.php file that invokes phpinfo()
- in phpinfo output, look at the "loaded plugins" line of the "mysqlnd" section

Expected:
- 'caching_sha2_password' should be listed.

Actual:
- 'caching_sha2_password' is *not* listed

Notes:
- starting in MySQL 8, the default password scheme is "caching_sha2_password".
- PHP didn't support this at first, see:
<https://bugs.php.net/bug.php?id=76243>
- that PHP bug is fixed by 7.4.13 (and even earlier).
- because it's missing, PHP can't talk to MySQL 8 by default, though a
workaround is to use 'mysql_native_password'
- Ubuntu 20.04 doesn't have this problem

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