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!