php8 mysql8 caching_sha2_password？

Question

mysql8 默认使用 caching_sha2_password 方式
PHP8 已经支持 但是安装完 phpinfo 并没有找到 caching_sha2_password
源码安装命令

./configure --prefix=/usr/local/php-8.3.9 --with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd --enable-fpm --enable-opcache=no
make && make install

是缺少了什么选项 还是 安装完需要修改什么配置呢
查了一天没查到，AI也没给个靠谱的方案
谢谢各位

Answer 1

试了一下，安装一下 openssl-devel，然后在 configure 参数上加上 --with-openssl 就好了

镜像：dokken/centos-stream-9

$ cat /etc/os-release
NAME="CentOS Stream"
VERSION="9"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="9"
PLATFORM_ID="platform:el9"
PRETTY_NAME="CentOS Stream 9"
ANSI_COLOR="0;31"
LOGO="fedora-logo-icon"
CPE_NAME="cpe:/o:centos:centos:9"
HOME_URL="https://centos.org/"
BUG_REPORT_URL="https://issues.redhat.com/"
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux 9"
REDHAT_SUPPORT_PRODUCT_VERSION="CentOS Stream"

$ yum install openssl-devel
$ ./configure --prefix=/usr/local/php-8.3.9 --with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd --enable-fpm --enable-opcache=no --with-openssl
$ make && make install
$ /usr/local/php-8.3.9/bin/php -i | grep "Loaded plugins"
Loaded plugins => mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password

参考：252420 – 'caching_sha2_password' support missing in PHP port, limits MySQL 8 compatibility

---

验证

以下代码来自 ChatGPT

-- 创建使用 caching_sha2_password 认证的用户
CREATE USER 'docker_user'@'%' IDENTIFIED WITH caching_sha2_password BY 'your_password';

-- 授权用户对所有数据库的访问权限
GRANT ALL PRIVILEGES ON *.* TO 'docker_user'@'%' WITH GRANT OPTION;

<?php
$host = 'host.docker.internal';  // Docker 中访问主机的特殊 DNS 名称
$db = 'test';
$user = 'docker_user';
$pass = 'your_password';
$charset = 'utf8mb4';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$options = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];

try {
    $pdo = new PDO($dsn, $user, $pass, $options);
    echo "Connected successfully!";
} catch (\PDOException $e) {
    throw new \PDOException($e->getMessage(), (int)$e->getCode());
}
?>