无法安装 WordPress 错误：“无法连接到数据库”

Question

Ubuntu 上的 Apache2，没有 SELinux。

我正在尝试安装 WordPress 的新服务器，但出现错误

cannot connect to database

我可以使用命令行登录

mysql -u user -p database

很好，端口 3306 是活的。

root@localhost:/home/www/services.com# netstat -an

Active Internet connections (servers and established)

Proto Recv-Q Send-Q Local Address           Foreign Address         State      

tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN     

tcp        0      0 127.0.0.53:53           0.0.0.0:*               LISTEN     

tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN          

tcp6       0      0 :::80                   :::*                    LISTEN

root@localhost:/home/www/services.com# cat wp-config.php

root@localhost:/home/www/services.com# ufw 状态

Status: inactive

完整错误：

Warning: mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] in /home/www/services.com/wp-includes/wp-db.php on line 1633

Warning: mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client in /home/www/services.com/wp-includes/wp-db.php on line 1633

The server requested authentication method unknown to the client

Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost. This could mean your host’s database server is down.

    Are you sure you have the correct username and password?

    Are you sure you have typed the correct hostname?

    Are you sure the database server is running?

If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

我还检查了用户名中的空格或错误，并阅读了许多其他类似的帖子。

如何让 WordPress 连接到 MySQL？

Answer 1

您使用的 MySQL 8 服务器已将caching_sha2_password插件设置为默认密码插件。（参见：https ://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html和https://dev.mysql.com/doc/refman/8.0/en/upgrading -from-previous-series.html#upgrade-caching-sha2-password）7.1.16 或 7.2.4 之前的 PHP 版本不支持caching_sha2_password.（见：https ://www.php.net/manual/en/mysqli.requirements.php ）mysql_native_password您可以通过直接在 mysql 控制台中使用查询来临时解决此问题：ALTER USER 'services.com'@'localhost' IDENTIFIED WITH mysql_native_password BY '1111';或者更好的是找到并编辑 my.cnf (Linux Distros) 或 my.ini 并将default_authentication_plugin值更改为：default_authentication_plugin=mysql_native_password并重新启动 MySQL 服务器。