php.ini与my.cnf里面的socket配置需一致

php.ini与my.cnf里面的socket配置需一致

---

---

1- php.ini配置

如果不配置php.ini里面的mysqli.default_socket和pdo_mysql.default_socket，那么他们的默认值是/tmp/mysql.sock，如果与/etc/my.cnf里面的不一致，那么会导致php无法正确连接mysql/mariadb。

vi  /etc/php.ini

#

mysqli.default_socket = /var/lib/mysql/mysql.sock 

#

pdo_mysql.default_socket = /var/lib/mysql/mysql.sock 

2- my.cnf配置

vi /etc/my.cnf

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

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

---

如上面所示,上面的四个socket的路径都应该保持一致。