When using mysqli function to connect to mysql under PHP, warning: mysqli::real_connect(): (hy000/1040): ..., mysqlihy000_PHP tutorial

When using mysqli function to connect to mysql under PHP, warning: mysqli::real_connect(): (hy000/1040): ..., mysqlihy000

Background: Replace mysql with Mysqli appears, there are too many connections, but it is not actually the case. 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 from mysql. I didn't find that there is really a connection. In fact, I used tshark to capture the package and I guess I can see it (http://justwinit.cn/post/7458/). No request was sent, but it was probably reported by the mysqli client itself. Although this problem is small, I have been working on it for a long time and want to reinstall Php. I found that the path was written wrong and the mysqli client prompted an error message that there were too many connections, causing the wrong direction. 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 //这个位置被挪动到,/data/runsock/mysqlsock/mysql.sock导致。

Remember to restart php-fpm after modification:

[root@iZ25z0ugwgtZ etc]# service php-fpm restart
Gracefully shutting down php-fpm . done
Starting php-fpm done

_______________The troubleshooting points are as follows_______________________________

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

Scenario: Manually compile and install mysql, and specify the installation location, php connects to mysql in localhost mode

Cause analysis: After manual compilation and installation, all mysql files are in the specified directory or data directory. By default, PHP will only look for /temp/mysql.sock to find this sock file, so it will As a result, the sock file cannot be found.

Solution:

1. Make a soft link to the sock file

ln -s /data/mysqldb/mysql.sock /tmp/mysql.sock;

or

2. Modify the default mysql.sock connection address of php

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

3. Use tcp socket to connect

mysql('127.0.0.1','username','passwod');

Let me introduce to you 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)

返回值

如果成功，则返回一个 MySQL 连接标识，失败则返回 FALSE。

提示和注释

注释：脚本一结束，到服务器的连接就被关闭，除非之前已经明确调用 mysql_close() 关闭了。
提示：要创建一个持久连接，请使用 mysql_pconnect() 函数。

例子

<&#63;php
$con = mysql_connect("localhost","mysql_user","mysql_pwd");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// 一些代码...
mysql_close($con);
&#63;>

您可能感兴趣的文章:

• mysql error 1130 hy000:Host''localhost''解决方案
• 详解远程连接Mysql数据库的问题(ERROR 2003 (HY000))
• mysql错误处理之ERROR 1786 (HY000)
• mysql错误处理之ERROR 1665 (HY000)
• MySQL错误ERROR 2002 (HY000): Can''t connect to local MySQL server through socket
• MySQL ERROR 2013 (HY000)错误解决方法
• mysql中一个普通ERROR 1135 (HY000)错误引发的血案