Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
linux, mysql, sockets, ubuntu
Solution
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.
Problem
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.