PHP code cannot connect to mysql

1. Get the current mysql.default_socket, mysqli.default_socket, pdo_mysql.default_socket configuration information

2. Get the MySQL socket path

Through the console Enter MySQL, enter the command: STATUS, and find the UNIX socket value.

3. Compare mysql.default_socket, mysqli.default_socket, pdo_mysql.default_socket and MySQL UNIX socket. It is found that they are different. This is the reason for the mysql_connect(); warning: There is a problem with PHP configuration mysql.

4. Reconfigure PHP, open php.ini and modify the values of mysql.default_socket, mysqli.default_socket, and pdo_mysql.default_socket to:/tmp/mysql.sock

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

Or modify the socket of my.cnf:

[client] socket=/tmp/mysql.sock [mysqld] socket=/tmp/mysql.sock

5. Restart nginx or apache

Recommended tutorial:PHP video tutorial

The above is the detailed content of PHP code cannot connect to mysql. For more information, please follow other related articles on the PHP Chinese website!