Wordpress：建立数据库连接时出错。是的，我已经尝试过了。还有那个

发布于 2024-09-18 07:37:59 字数 1917 浏览 3 评论 0原文

这让我抓狂！我的 MacBook Pro 上安装了一个 Wordpress 测试实例，但它突然停止工作。如果我前往 http://localhost:9003/wp-admin/ 我得到：

建立数据库连接时出错
这要么意味着用户名和密码信息在您的 wp-config.php 文件不正确或者我们无法联系数据库服务器位于本地主机。这可能意味着您主机的数据库服务器已关闭。
你确定你有正确的用户名和密码？
你确定吗您输入了正确的内容主机名？
您确定数据库服务器正在运行？
如果你是不确定这些术语对您意味着什么也许应该联系你的主人。如果你仍然需要帮助，你可以随时访问 WordPress 支持论坛。

哼！我已经很久没有碰过配置了。以下是相关行现在的样子：

define('DB_NAME', 'wordpress');
define('DB_USER', 'wordpress');
define('DB_PASSWORD', 'wordpress');
define('DB_HOST', 'localhost');
$table_prefix  = 'wp_';

这些值都很好：

$ mysql -h localhost -u wordpress --password=wordpress \
> wordpress -e 'select user_login from wp_users'
+------------+
| user_login |
+------------+
| simon      |
+------------+

MySQL 错误日志中没有任何内容，Apache 的错误日志中也没有任何内容。我尝试过使用不同的 MySQL 用户和不同的数据库，但出现相同的错误。我很沮丧 - 有 WordPress 专家知道我错过了什么吗？

php --ri mysql 的输出：

$ php --ri mysql

mysql

MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $

Directive => Local Value => Master Value
mysql.allow_persistent => On => On
mysql.max_persistent => Unlimited => Unlimited
mysql.max_links => Unlimited => Unlimited
mysql.default_host => no value => no value
mysql.default_user => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => /var/mysql/mysql.sock => /var/mysql/mysql.sock
mysql.connect_timeout => 60 => 60
mysql.trace_mode => Off => Off
mysql.allow_local_infile => On => On

原文

This is driving me nuts! I have a test instance of Wordpress installed on my MacBook Pro, which has suddenly stopped working. If I head for http://localhost:9003/wp-admin/ I get:

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
that you have typed the correct
hostname?
Are you sure that 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.

Hmmph! I haven't touched the config for ages. Here's how the relevant lines look right now:

define('DB_NAME', 'wordpress');
define('DB_USER', 'wordpress');
define('DB_PASSWORD', 'wordpress');
define('DB_HOST', 'localhost');
$table_prefix  = 'wp_';

The values are all good:

$ mysql -h localhost -u wordpress --password=wordpress \
> wordpress -e 'select user_login from wp_users'
+------------+
| user_login |
+------------+
| simon      |
+------------+

There's nothing in the MySQL error log, nor in Apache's error log. I've tried using a different MySQL user and a different database, but I get the same error. I'm scuppered - any WordPress gurus out there know what I'm missing?

Output of php --ri mysql:

$ php --ri mysql

mysql

MySQL Support => enabled
Active Persistent Links => 0
Active Links => 0
Client API version => mysqlnd 5.0.7-dev - 091210 - $Revision: 294543 $

Directive => Local Value => Master Value
mysql.allow_persistent => On => On
mysql.max_persistent => Unlimited => Unlimited
mysql.max_links => Unlimited => Unlimited
mysql.default_host => no value => no value
mysql.default_user => no value => no value
mysql.default_password => no value => no value
mysql.default_port => no value => no value
mysql.default_socket => /var/mysql/mysql.sock => /var/mysql/mysql.sock
mysql.connect_timeout => 60 => 60
mysql.trace_mode => Off => Off
mysql.allow_local_infile => On => On

分享到QQ

分享到微博