mysql使用sha256密码,使用sha256_password（访问被拒绝）时如何使用PHP的mysqli连接到MySQL...

最新推荐文章于 2024-07-27 02:05:20 发布

河星星

最新推荐文章于 2024-07-27 02:05:20 发布

阅读量1k

点赞数

文章标签： mysql使用sha256密码

在MySQL 5.7.24和PHP 7.2.10环境下，配置了SSL并尝试使用sha256_password认证时，PHP的mysqli连接遇到访问拒绝问题。当切换到mysql_native_password时可以成功连接。本文探讨了如何在PHP中正确使用sha256_password进行连接，并提供了相关phpinfo()的诊断信息。

摘要由CSDN通过智能技术生成

I'm using MySQL 5.7.24 and PHP 7.2.10. MySQL is configured with SSL. I have a user my_user with password abc123. I have tried configuring with both authentication plugins:

ALTER USER 'my_user'@'192.168.192.150' IDENTIFIED WITH sha256_password BY 'abc123';

ALTER USER 'my_user'@'192.168.192.150' IDENTIFIED WITH mysql_native_password BY 'abc123';

From my PHP server, I can successfully connect using the mysql command line client without specifying anything other than the host, user, and password. However, from PHP, I can connect only when using mysql_native_password. Not when using sha256_password.

The following PHP code works fine with mysql_native_password:

$mysqli = mysqli_init();

$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5);

$con = $mysqli->real_connect('192.168.19