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)
This is the MySQL info listed in my config file (which I believe is correct):
"type" => "Mysql",
"user" => "root",
"pass" => "******",
"host" => "localhost",
"port" => "",
"db" => "******"
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.
解决方案
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:
Open your my.cnf file
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
The error should be gone. Many thanks to @alvits for pointing me in the right direction.