Mysql – “Waiting for initial communication packet” error 0 in MySQL

MySQL

I am using MySQL server 5.1.51 on a Linux machine.

The application was working fine for the last 32 days, but since yesterday a number of clients are not able to connect to the database from our application. They are getting the following error:

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

What can I do to fix this? Where is my.ini located in Windows XP?

Best Answer

Adding the following database parameter to my.ini solved my problem:

skip_name_resolve

This parameter skips host name resolution during connection establishment with the MySQL database server.

Related Solutions

Sql-server – 64-Bit OLEDB Provider for ODBC (MSDASQL) issues

Ok, just read this on a blog. YMMV

http://www.ryanjadams.com/2011/03/dsn-windows-64bit/

Mysql – “Connection to host lost” using telnet to MySQL

What you're seeing with the telnet test looks like normal behavior, since mysql doesn't "speak telnet," so the result may not be all that helpful... all it really tells us is that a TCP connection to the remote machine is at least possible.

sqlbot@dev:~$ telnet 10.20.30.40 3306
Trying 10.20.30.40...
Connected to 10.20.30.40.
Escape character is '^]'.
N
5.5.15-log|     \Q_l"`>SÀh4e$~rA/b$'9mysql_native_passwordConnection closed by foreign host.

sqlbot@dev:~$

A better test would be to try the MySQL command line client -- from the same machine where you're getting the error from on workbench. Whether that succeeds or fails will probably be more informative.

How long does it take for the message to appear?

Best Answer

Related Solutions

Sql-server – 64-Bit OLEDB Provider for ODBC (MSDASQL) issues

Mysql – “Connection to host lost” using telnet to MySQL

Related Question