Cannot connect to database server，与数据库断开连接

mysql的配置文件

linux：/etc/mysql/my.cnf

windows：D:\Program Files\mysql\bin\my.ini

这里有如下几种方法：

• changing "bind-address" attribute

Uncomment "bind-address" attribute or change it to one of the following IPs:

bind-address="127.0.0.1"

or

bind-address="0.0.0.0"

• commenting out "skip-networking"

If there is a "skip-networking" line in your MySQL config file, make it comment by adding "#" sign at the beginning of that line.

• change "wait_timeout" and "interactive_timeout"

Add these lines to the MySQL config file:

wait_timeout = number

interactive_timeout = number

connect_timeout = number

• check Operating System proxy settings

Make sure the Fire wall, or Anti virus soft wares don't block MySQL service.

• change connection string

Check your query string. your connection string should be some thing like this:

dbName = "my_database";

Don't forget to change username and password to the username and password of your MySQL server.

• update your JDK driver library file
• test different JDK and JREs (like JDK 6 and 7)
• don't change max_allowed_packet

"max_allowed_packet" is a variable in MySQL config file that indicates the maximum packet size, not the maximum number of packets. So it will not help to solve this error.

• change tomcat security

change TOMCAT6_SECURITY=yes to TOMCAT6_SECURITY=no

• use validationQuery property

use validationQuery="select now()" to make sure each query has responses

• AutoReconnect

Add this code to your connection string:

&autoReconnect=true&failOverReadOnly=false&maxReconnects=10

My problem was that I had many SELECTs on database. Each time I was creating a connection and then closing it. Although I was closing the connection every time, but the system faced with many connections and gave me that error. What I did was that I defined my connection variable as a public (or private) variable for whole class and initialized it in the constructor. Then every time I just used that connection. It solved my problem and also increased my speed dramatically.

Conclusion

There is no simple and unique way to solve this problem. I suggest you to think about your own situation and choose above solutions. If you take this error at the beginning of the program and you are not able to connect to the database at all, you might have problem in your connection string. But If you take this error after several successful interaction to the database, the problem might be with number of connections and you may think about changing "wait_timeout" and other MySQL settings or rewrite your code how that reduce number of connections.