我得到了由DigitalOcean托管的WordPress网站的Error establishing a database connection
。所以我检查了数据库的问题。
sudo /etc/init.d/mysql restart
返回
stop: Unknown instance:
start: Job failed to start
df -h /
返回以下信息,那么磁盘是否未满?
Filesystem Size Used Avail Use% Mounted on
/dev/disk/by-label/DOROOT 20G 12G 6.9G 63% /
sudo -u mysql mysqld
返回
170828 4:33:48 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170828 4:33:48 [Note] mysqld (mysqld 5.5.52-0ubuntu0.14.04.1) starting as process 18825 ...
mysqld
返回
170828 4:34:17 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170828 4:34:17 [Note] mysqld (mysqld 5.5.52-0ubuntu0.14.04.1) starting as process 18866 ...
170828 4:34:17 [Warning] Can't create test file /var/lib/mysql/chengtie.lower-test
170828 4:34:17 [Warning] Can't create test file /var/lib/mysql/chengtie.lower-test
mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13)
170828 4:34:17 [ERROR] Aborting
170828 4:34:17 [Note] mysqld: Shutdown complete
那么有人知道mysql出了什么问题吗?我该如何重新启动它?
编辑1:我注意到/var/lib/mysql/phpmyadmin
下没有config.inc.php
或config.sample.inc.php
。
你看了这篇文章吗:Ubuntu-12.04-MySql赢了';t使用服务mysql启动
您可以尝试
mysqld--verbose来获取更多信息
mysqld:无法将目录更改为"/var/lib/mysql/"(错误代码:13(
这就是"权限"。我怀疑MySQL是以root以外的用户身份安装的。建议您重新安装(以root用户身份(,尤其是在您还没有任何数据的情况下。
/var/lib/mysql/似乎存在权限问题
https://dba.stackexchange.com/a/106135
define('DB_HOST', 'localhost');
不应该是'localhost',它应该是mysql服务器的主机名。