Error Lost connection to MySQL server at reading initial communication packet system

Question

When I try to connect to database I'm ending getting with this error:

"Lost connection to MySQL server at 'reading initial communication packet, system error: 0"

And when I am using my live IP address like below, it's getting error:

mysql_connect("202.131.xxx.106:xxxx", "xxxx", "xxxxx") or die(mysql_error())

Answer 1

Hello,

You have to follow the below steps:

1. bind-address = "YOUR MACHINE IP" in my.cnf file at /etc/my.cnf

2. Restart service by command : service httpd restart

3. GRANT ALL PRIVILEGES ON yourDB.* TO 'username'@'YOUR_APPLICATION_IP' IDENTIFIED BY 'YPUR_PASSWORD' WITH GRANT OPTION;

Hope this work fine!!

Thank You!

To know more about SQL, It's recommended to join MS SQL Course today.