Date: Mon, 04 Jan 2021 21:02:29 +0000 From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 252420] 'caching_sha2_password' support missing in PHP port, limits MySQL 8 compatibility Message-ID: <bug-252420-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D252420 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@FreeBSD.org Reporter: sean@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" sec= tion 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_passwor= d". - PHP didn't support this at first, see: <https://bugs.php.net/bug.php?id=3D76243>; - 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 --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-252420-7788>