进入你的wp-config.php 并更改您的DB_HOST 到127.0.0.1 而不是本地主机。

上面的评论归功于克雷格·韦恩。

对我来说，答案是改变DB_HOST 到127.0.0.1:8889 而不是localhost 在里面wp-config.php, 并选中MySQL设置中的“允许网络访问MySQL”框。将端口设置为MAMP Pro用于数据库的端口是我在这里的其他答案中没有看到的关键缺失部分。YMMV。

确保使用MAMP PHP二进制文件。您可以检查运行WP CLI的PHP版本

php wp-cli.phar --info

PHP_VERSION=$(ls /Applications/MAMP/bin/php/ | sort -n | tail -1)
export PATH=/Applications/MAMP/bin/php/${PHP_VERSION}/bin:$PATH

source ~/.bash_profile

  php wp-cli.phar --info

这其中有两个部分需要协同工作：

-您需要从localhost 到127.0.0.1 并在末尾添加端口号。对我来说127.0.0.1:3306.

端口号位于Mamp中的MySQL面板中。

步骤1：检查mysql服务器是否正在运行步骤2：如果是，则可以使用

mysql -u root -p

show databases;
grant all privileges on database_name.* to \'root\'@\'localhost\' identified by \'password\';
flush privileges;
exit;

define(\'DB_NAME\', \'db_name\');
define(\'DB_USER\', \'root\');
define(\'DB_PASSWORD\', \'password\');
define(\'DB_HOST\', \'localhost\');

在我的情况下，除了上述错误消息外，我还收到了以下警告：

PHP Warning:  mysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1531
Warning: mysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1531
PHP Warning:  mysqli_real_connect(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1531
Warning: mysqli_real_connect(): (HY000/2054): Server sent charset unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1531
PHP Deprecated:  mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/www/html/wp-includes/wp-db.php on line 1562
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/www/html/wp-includes/wp-db.php on line 1562
PHP Warning:  mysql_connect(): Server sent charset (255) unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1562
Warning: mysql_connect(): Server sent charset (255) unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1562
PHP Warning:  mysql_connect(): Server sent charset unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1562
Warning: mysql_connect(): Server sent charset unknown to the client. Please, report to the developers in /var/www/html/wp-includes/wp-db.php on line 1562

事实上，我可以通过从MySQL 5.7升级到MySQL 8.0来复制错误

我通过导出数据库、降级到MySQL 5.7并重新导入数据解决了这个问题。我还对MariaDB 10.3进行了测试，效果很好。

在我的情况下，我必须按照eknows在他的解决方案中提出的建议去做(https://wordpress.stackexchange.com/a/313862/172520) 当然，还可以为我的Mac启用对MySQL的网络访问（使用MAMP Pro）。

如果您在WordPress多站点上使用某些WP操作，也可能会出现此错误，在这种情况下，您需要指定URL，例如--URL=mysite。组织机构