在ubuntu上安装好Navicat后，连接mysql数据库（也是安装在ubuntu上）发现报了以下错误：

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
解决方法：

第一步：打开配置文件

$ sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

第二步：修改配置文件

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
#socket         = /var/run/mysqld/mysqld.sock
socket          = /var/lib/mysql/mysql.sock
port            = 3306
datadir         = /var/lib/mysql

[client]

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

修改socket为/var/lib/mysql/mysql.sock,并添加

client]

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

3.重启mysql服务

$ sudo service mysql restart