想在mysql服务器中导出数据库，用来暂时备份用，执行以下语句：
./mysqldump -d db -u root -p >db.sql

却报如下错误：
```
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect
```
一般我们使用数据库都不会遇到这个问题，这估计是前人安装数据库时不负责，或者不按规范安装留下祸根，百度了下，最简单的解决办法是，找到当前mysql.sock的位置，修改/etc/my.cnf，增加如下配置：
```
[client]
socket=/var/lib/mysql/mysql.sock
```
重启数据就可以了

我贴一下我my.cnf完整的配置：
```
[mysql]
socket=/var/lib/mysql/mysql.sock
# set mysql client default chararter
default-character-set=utf8

[mysqld]
socket=/var/lib/mysql/mysql.sock
# set mysql server port
port = 3306
# set mysql install base dir
basedir=/usr/local/mysql
# set the data store dir
datadir=/usr/local/mysql/data
# set the number of allow max connnection
max_connections=3000
# set server charactre default encoding
character-set-server=utf8
# the storage engine
default-storage-engine=INNODB
lower_case_table_names=1
max_allowed_packet=16M
explicit_defaults_for_timestamp=true

# 取消密码验证
#skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# skip-grant-tables

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql.server]
user=mysql
basedir=/usr/local/mysql

[client]
socket=/var/lib/mysql/mysql.sock

```

ClassInstance

Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect

相关文章

推荐文章

热门文章

标签列表