Connect to MySQL from a different server

awesome_aims

Hi, i need connect with the MySQL from a different server, if tried everything and it's still not letting me, through cpanel I allowed the host to access the mysql, and I'm trying to connect like this:
mysql_connect("11.111.1.111", "username", "password");
it's returning the error:
"Warning: mysql_connect(): Lost connection to MySQL server during query in /home/awesomea/public_html/csp.php on line 6"
iv'e also tried connecting to ports: 11.111.1.111:3306
and its returning the same error

FatalError

"Warning: mysql_connect(): Lost connection to MySQL server during query in /home/awesomea/public_html/csp.php on line 6"

There's something with your host most likely. It has nothing to do with the code. Maybe contact them about it?

Roger_Ramjet

Has the user you are connecting as been granted the neccessary read/write privileges on the tables? They have to be granted to the user for the host you are connecting FROM, or a wildcard '%' used to allow from any host - which would be very unwise.

FatalError

Roger Ramjet wrote:
Has the user you are connecting as been granted the neccessary read/write privileges on the tables? They have to be granted to the user for the host you are connecting FROM, or a wildcard '%' used to allow from any host - which would be very unwise.

Wouldn't that still give a different error though? I don't know...haven't really had this problem myself...