MysqlNote

• 刚安装完 php5-fpm mysql 使用 phpMyAdmin 登陆提示如下错误

#2002 - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) — The server is not responding (or the local server's socket is not correctly configured).

• 因为使用源码编译安装的 mysql 5.7 的默认配置文件 /etc/mysql/my.cnf 没有 [client] 这一段配置.而默认的 mysql sock 位置为 /var/run/mysqld/mysqld.sock

1. 首先找到所有的 socket 文件:

yzhang@coam:~$ sudo find / -type s
/tmp/mongodb-27017.sock
/tmp/mysql/mysql.sock
/run/fail2ban/fail2ban.sock
...

所以手动 /etc/mysql/my.cnf 添加这一行:

[client]
socket=/tmp/mysql/mysql.sock <= this path should be also same as is[mysqld]

• 重启 mysql

sudo service mysql restart

• 最简单的方法是建立软连接 /tmp/mysql/mysql.sock => /var/run/mysqld/mysqld.sock

sudo ln -s /tmp/mysql/mysql.sock /var/run/mysqld/mysqld.sock

• 据说以下也可以解决此问题的一个途径,记录一下

/usr/bin/mysql -u root -p -S /home/mysql/mysql.sock

参考列表

• 使用 phpMyAdmin 登陆 Mysql,用户名密码都没错,但是一直提示如下错误 error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’(2)’

error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
Cannot connect to mysql server ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)

• 最根本的原因是 /etc/php5/fpm/php.ini 中的三个配置段 {[Pdo_mysql]pdo_mysql.default_socket = |[MySQL]mysql.default_socket = |[MySQLi]mysqli.default_socket = |} 默认留空,也就是为默认的 /var/run/mysqld/mysqld.sock

• 使用 vi 搜索 .default_socket 将其改为 {[Pdo_mysql]pdo_mysql.default_socket = /tmp/mysql/mysql.sock|[MySQL]mysql.default_socket = /tmp/mysql/mysql.sock|[MySQLi]mysqli.default_socket = /tmp/mysql/mysql.sock|}

vi /etc/php5/fpm/php.ini

[Pdo_mysql]
...
pdo_mysql.default_socket = /tmp/mysql/mysql.sock
...

[MySQL]
...
mysql.default_socket = /tmp/mysql/mysql.sock
...

[MySQLi]
...
mysqli.default_socket = /tmp/mysql/mysql.sock
...

• 重启 php5-fpm 生效

注 没有修改 /etc/php5/cli/php.ini

---