Shulou(Shulou.com)06/03 Report--

This article mainly introduces "how to solve the problem of warning: mysqli::real_connect (): (hy000/1040) in connecting mysql with mysqli under PHP. In daily operation, I believe that many people use the function of mysqli to connect mysql under PHP. There are doubts about how to solve the problem: mysqli::real_connect (): (hy000/1040). The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubt that "warning: mysqli::real_connect (): (hy000/1040) how to solve the problem of connecting mysql using mysqli functions under PHP"! Next, please follow the editor to study!

Background: when mysql is replaced with mysqli, there are too many connections, which is actually not. The reason is that I moved the sock file location of php. Because these socket modifications were not completely modified, too many connections appeared. Show processlist did not find a real connection from mysql. In fact, you can use tshark to grab the package and estimate that you can see it. No request has been made. It is estimated that the client of mysqli reported it by itself. despite the minor problem, I wanted to reinstall Php for a long time. I found that the path was written wrong and the client of mysqli went in the wrong direction because of the excessive number of connections. As follows:

[root@iZ25z0ugwgtZ etc] # grep-r "mysql.sock". /. / php.ini:pdo_mysql.default_socket=/data/runsock/mysqlsock/mysql.sock./php.ini:;mysql.default_socket = / tmp/mysql.sock./php.ini:mysql.default_socket = / data/runsock/mysqlsock/mysql.sock./php.ini:mysqli.default_socket = / data/runsock/mysql.sock / / this position is moved, caused by / data/runsock/mysqlsock/mysql.sock.

Remember to restart php-fpm after modification:

[root@iZ25z0ugwgtZ etc] # service php-fpm restartGracefully shutting down php-fpm. DoneStarting php-fpm done

_ _ the main points of troubleshooting are as follows _ _

Warning: mysqli::real_connect (): (hy000/1040): too many connections in:

There is a scenario: manually compile and install mysql, and determine the installation location, and php connects to mysql in localhost mode

Reason analysis: after manual compilation and installation, all mysql files are in the established directory or data directory, php will only look for / temp/mysql.sock to find this sock file by default, so it will cause the sock file to be unable to find.

Solution:

1. Make a soft chain for the sock file

Ln-s / data/mysqldb/mysql.sock / tmp/mysql.sock

Or

two。 Modify the default mysql.sock connection address for php

Mysql.default_socket=/data/mysqldb/mysql.sock

3. Connect using tcp socket

Mysql ('127.0.0.1' recording 'username'', 'username'', 'passwod')

Next, let's introduce the PHP mysql_connect () function.

Definition and usage

The mysql_connect () function opens a non-persistent MySQL connection.

Grammar

Mysql_connect (server,user,pwd,newlink,clientflag) parameter describes server

Optional. Specify the server to connect to.

You can include the port number, such as "hostname:port", or the path to the local socket, such as ": / path/to/socket" for localhost.

If the PHP directive mysql.default_host is not defined (default), the default value is' localhost:3306'.

User is optional. User name. The default value is the user name of the server process owner. Pwd is optional. Password. The default value is an empty password. Newlink is optional. If mysql_connect () is called a second time with the same parameters, no new connection will be established, but the identity of the connection that has already been opened will be returned. The parameter new_link changes this behavior and causes mysql_connect () to always open a new connection, even when mysql_connect () has been called with the same parameter earlier. Clientflag

Optional. The client_flags parameter can be a combination of the following constants:

MYSQL_CLIENT_SSL-use SSL encryption

MYSQL_CLIENT_COMPRESS-use compression protocol

MYSQL_CLIENT_IGNORE_SPACE-the interval after the name of the allowed function

MYSQL_CLIENT_INTERACTIVE-allows interaction timeout inactivity before closing the connection

Return value

A MySQL connection ID is returned if successful, or FALSE if failed.

Tips and comments

Note: as soon as the script ends, the connection to the server is closed unless you have explicitly called mysql_close () to close it before.

Tip: to create a persistent connection, use the mysql_pconnect () function.

Examples

At this point, on the "PHP using mysqli functions to connect mysql warning: mysqli::real_connect (): (hy000/1040) how to solve" on the end of the study, I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.