PHP 7.2.2 + mysql 8.0 PDO 给出:客户端未知的身份验证方法 [caching_sha2_password]

2021-12-26 00:00:00 php mysql pdo

我使用的是 php 7.2.2 和 mysql 8.0.

I'm using php 7.2.2 and mysql 8.0.

当我尝试使用正确的凭据进行连接时,出现此错误:

When I try to connect with the right credential I get this error:

PDOException::("PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password]")

需要帮助来解决问题.

推荐答案

如果你想用 MySQL >= 8 又不关心caching_sha2_password,安装时选择第二个选项即可.

If you want to use MySQL >= 8 and you don't care about caching_sha2_password, just select the second option when you install.

相关文章