php pdo connection error Connection failed: SQLSTATE[HY000] [2002]_PHP tutorial

php pdo connection error Connection failed: SQLSTATE[HY000] [2002]

Let’s take a look at php pdo_mysql connection error Connection failed: SQLSTATE[HY000] [2002] No such Solution to file or directory problem.

Error

Connection failed: SQLSTATE[HY000] [2002] No such file or directory

Environment overview:

MacOS

Development environment apache mysql php built by xampp

xampp has supported mysql oracle, the test is ok, and phpinfo has shown that it supports pdo_mysql pdo_pgsql pdo_sqlite

Among them, I used brew package management to install mysql into the machine, instead of the mysql that comes with xampp

　php pdo connection error Connection failed: SQLSTATE[HY000] [2002] No such file or directory

At first I thought that the file cannot be found because of url rewrite, (because I switched from nginx to apache) but the tracking program found that the new pdo error was reported

After searching some information, I found:

This is the wrong mysql.sock path specified by pdo_mysql.default_socket in the php.ini configuration file

My mysql.sock file is in /private/tmp/mysql.sock

So set:

pdo_mysql.default_socket=/private/tmp/mysql.sock

If you don’t know where your mysql.sock is, you can search it (because the compilation and installation are different from the installation locations of package management tools such as yum, apt-get, or brew)

sudo find / -name ‘mysql.sock’

The following is the official bug fix

　1. Open up php.ini (mine was in /private/etc/)

　2. locate this line: pdo_mysql.default_socket=/var/mysql/mysql.sock

　3. Change the line to: pdo_mysql.default_socket=/tmp/mysql.sock

　4. Restart apache

1. I need to add here that if it is a new system or someone who has just started playing PHP, the php.ini file does not exist in the Mac system,

　2. Need to cp php.ini.default

php.ini, and then modify it,

3. But if you use xampp mysql as the database, then you don’t need to use the official step 2, just write the following method.

pdo_mysql.default_socket=/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock

Solution three

sudo vim /etc/php.ini

Set the following three originally blank values ​​​​to /tmp/mysql.sock

　mysql.default_socket = /tmp/mysql.sock

pdo_mysql.default_socket= /tmp/mysql.sock

mysqli.default_socket =/tmp/mysql.sock

All modified

Use after modification is completed

sudo /usr/sbin/apachectl restart