当前位置: 动力学知识库 > 问答 > 编程问答 >

linux - waiting for initial communication packet error 0 while connecting to mysql database server

问题描述:

I am using mysql server 5.1.51 on linux machine

Application was working fine from last 32 days but yesterday onward number of client are not able to connect to the database using application and getting below error

-2147467259 [MySQL] [ODBC 5.1 Driver] Lost Connection to MySQL server at 'waiting for initial communication packet',system error: 0

Please suggest what are possible causes for this

网友答案:

Adding below mentioned database parameter into my.ini solved my problem skip-name-resolve

[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
skip-name-resolve

This parameter skips host name resolving during establishment of application's connection with mysql database server

分享给朋友:
您可能感兴趣的文章:
随机阅读: