Error Lost connection to MySQL server at reading initial communication packet system
When I try to connect to the database I'm ending getting 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())
Lost connection to MySQL server at 'reading initial communication packet' There seems to be a problem with the firewall blocking outside connection.
To resolve this error you have to follow the below steps:
bind-address = "YOUR MACHINE IP" in my.cnf file at /etc/my.cnf
Restart service by command : service httpd restart
GRANT ALL PRIVILEGES ON yourDB.* TO 'username'@'YOUR_APPLICATION_IP' IDENTIFIED BY 'YPUR_PASSWORD' WITH GRANT OPTION;
Hope this works!!