Bdtyktl

Here are the following commands I have done.

$ sudo service mysql start

mysql start/running



$ mysql -u root

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)



$ aptitude search mysql |grep ^i

i   libapache2-mod-auth-mysql       - Module Apache 2 pour l'authentification vi

i   libdbd-mysql-perl               - Perl5 database interface to the MySQL data

i   libmysqlclient16                - MySQL database client library             

i   mysql-client-5.1                - MySQL database client binaries            

i   mysql-client-core-5.1           - MySQL database core client binaries       

i   mysql-common                    - MySQL database common files, e.g. /etc/mys

i   mysql-server-5.1                - MySQL database server binaries and system 

i   mysql-server-core-5.1           - MySQL database server binaries            

i   php5-mysql                      - MySQL module for php5                     

Before reinstalling check /var/log/mysql for logs files which may contain clues as to why mysql is not working. If there are no logs log to file might not be enabled in your configuration: Configure Mysql Error Log

To reinstall any package check installed version with

dpkg -l|grep mysql-server

then for version 5.7 use

sudo apt-get install mysql-server-5.7 --reinstall

If this doesn't allow you to reconfigure the package you can use

sudo dpkg-reconfigure mysql-server-5.7

ERROR 2002 (HY000): Can not connect to local MySQL server-through socket '/ tmp / mysql.sock' (2)

In MySQL installations can specify where we will have the socket for local connections. When making updates is not uncommon to see the error "Can not connect to local MySQL server socket-through." Let's see how to solve this problem.

The error look like this:

Mysql-u root-p

Enter password:

ERROR 2002 (HY000): Can not connect to local MySQL server-through socket '/ tmp / mysql.sock' (2)

thru ps we can see if is specified by parameter and the place where is it:

# ps -fea | grep mysqld

mysql    17661 14003  1 Feb19 ?        00:24:59 /usr/local/mysql-percona/libexec/mysqld --basedir=/usr/local/mysql-percona --datadir=/var/data/mysql/datadir/data --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log

root     23790  7840  0 09:25 pts/0    00:00:00 grep mysqld

In this case we see is in /var/lib/mysql/mysql.sock. If not found as a parameter should look into mysqld section of /etc/my.cnf to find the parameter:

grep socket /etc/my.cnf

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

If we know where is it we need to modify the same file (/etc/my.cnf) and add the parameter section socket client:

[client]

default-character-set=utf8

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

For the latter viewers:

I came to the similar error when I failed to upgrade mysql-server package， but I found this solved my problem.
When sudo apt-get install -f doesn't work, try sudo apt-get purge mysql*. Now you can reinstall mysql-server.

One of the problems I am running into is knowing which version I am having issues with.
This was a neat idea:

$ aptitude search mysql |grep ^i

But here's what I found was critical in the issue:

$ apt-get --reinstall install mysql-server-5.x

(where x is the version. If you don't add this, you could be working with the wrong dpkg.