Lost connection to MySQL server at 'reading initial communication packet', system err

manishsingh4k · 07-20-2009, 04:24 AM

Hi All,

I am connecting mysql database server through php script remotly. PHP files on other server and the database is on another. While trying to connect, i get this error message below.

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 113

Please suggest me how to get it connected.
Thanks in advance

weibullguy · 07-20-2009, 05:30 AM

Are you using iptables and does iptables allow MySQL connections?

PMP · 07-20-2009, 05:47 AM

Try telnet to port of mysql defaults to 3306

manishsingh4k · 07-20-2009, 06:18 AM

I am not using IP tables. also i tried telnet, it says "connection to host lost"

EricTRA · 07-20-2009, 06:44 AM

Does your MySQL server listens on the IP or only on the localhost? Check my.cnf to find out.

Kind regards,

Eric

PMP · 07-20-2009, 06:53 AM

Are you able to ping the server which hosts mysql

manishsingh4k · 07-20-2009, 07:08 AM

please suggest how to view/modify the my.cnf, also how can we see the settings of IP / localhost. Yes I am able to ping the server which hosts mysql

EricTRA · 07-20-2009, 07:14 AM

Hello,

On a default installation, depending the distro you use, the file you need to check is found in /etc/mysql and named my.cnf.

If that directory doesn't exist, look for the file using find / -name 'my.cnf' and you'll know where it is.

So 'cd' to the directory or edit using your favorite editor (vi, nano, ...).

Look for the line that says

bind-address =

If that is set to 127.0.0.1 or something else, change it to the IP of your server. The IP of your server should be known by you, or can be found using 'ifconfig' command (on Debian) or with 'ip addr sh eth0' for the first network card.

After changing the my.cnf file you need to reboot the MySQL server, normally using '/etc/init.d/mysql restart'

Kind regards,

Eric

PMP · 07-20-2009, 07:31 AM

Provide the IP of the machine from which you are making the connection.
The user from which you are making the connection

and the output of this query

Code:

select host,user,Select_priv from mysql.user;