无法通过套接字'/var/lib/mysql/mysql.sock'连接到本地MySQL服务器(2) [英] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

问题描述

我刚刚在WordPress网站上手动安装了一个新插件，并在MySQL中为该插件的条目创建了一个表，当我尝试打开使用该插件的页面时，出现此错误:

I just manually installed a new plugin on my WordPress site, created a table in MySQL for the plugin's entries, and when I try to open the page that uses the plugin, I receive this error:

DataTables warning (table id = 'to-do_list'): An error occurred while 
connecting to the database 'wordpress_clouse'. The error reported by the 
server was: SQLSTATE[HY000] [2002] Can't connect to local MySQL server 
through socket '/var/lib/mysql/mysql.sock' (2)

这是我的配置文件中列出的MySQL信息(我认为是正确的):

This is the MySQL info listed in my config file (which I believe is correct):

"type" => "Mysql",
"user" => "root",
"pass" => "******",
"host" => "localhost",
"port" => "",
"db"   => "******"

这是/etc/my.cnf文件的主要内容:

This is the main contents of the /etc/my.cnf file:

# The following options will be passed to all MySQL clients
[client]
#port       = 3306
socket      = /var/run/mysqld/mysqld.sock

# The MySQL server
[mysqld]
#port       = 3306
socket      = /var/run/mysqld/mysqld.sock
log_error   = mysqld.err

skip-networking

我已经查看了类似错误的答案，但是没有一个解决方案对我有用.任何帮助将不胜感激.

I've looked at answers to similar errors but none of the solutions worked for me. Any help would be appreciated.

推荐答案

以下是帮助我解决此问题的原因，即我服务器上的实际文件目录为/var/lib/mysql/mysql.sock ，而不是/var/lib/mysqld/mysqld.sock:

Here's what helped me solve this problem, which was that the actual file directory on my server was /var/lib/mysql/mysql.sock, not /var/lib/mysqld/mysqld.sock:

1. 打开您的 my.cnf 文件
2. 将以下内容添加到您的[client]部分(如果没有[client]部分，则将其添加).它应该看起来像这样:

1. Open your my.cnf file
2. Add the following to your [client] section (if you don't have a [client] section, then add it). It should look like this:

[客户]

[client]

socket =/var/lib/mysql/mysql.sock

socket=/var/lib/mysql/mysql.sock

错误应该消失了.非常感谢@alvits为我指出正确的方向.

The error should be gone. Many thanks to @alvits for pointing me in the right direction.

这篇关于无法通过套接字'/var/lib/mysql/mysql.sock'连接到本地MySQL服务器(2)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！