Jump to content
xisto Community
rockarolla

Lost Connection To Mysql ,..., System Error: 111 In

Recommended Posts

While I was trying to connect to my database or even create one using PhP mySQL I was given the followoing error:Lost connection to MySQL server at 'reading initial communication packet', system error: 111 inHas somebody encontered a similar report? I have my database created using the cpanel together with a user name and password.I wonder if it is a server issue? What can you do if you have not access to the configuration files?

Edited by rockarolla (see edit history)

Share this post


Link to post
Share on other sites

I don't think so. Here is my code. Its a very simple code just to see if I can ever establish a connection with my database:

function open_connection() {		$host='localhost:3307';		$user='any';		$db='my_db';		$password='my_pass';		$conn=mysql_connect($host,$user,$password);		mysql_create_db ($db,$conn);		mysql_select_db($db);	return $conn;}

If I call this function within my file I get the error:

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in

I've looked about several forums and I didn't get any concern to my code.

Also I tried using mysql_pconnect() as someone suggested that the problem maybe dropping connection, but it didn't work as well.

I don't have any rights to configure neither php nor mysql. So I guess the provider doesn't want anyone to connect to their database...

On the same host I cannot use code like this:

function add_hits(){		$opFile = fopen ("counter.txt", "r");		$handle = fread ($opFile, filesize ("counter.txt"));		fclose ($opFile);				 . . .

so I think at the end that this is a server issue.
Edited by rockarolla (see edit history)

Share this post


Link to post
Share on other sites

I don't think so. Here is my code. Its a very simple code just to see if I can ever establish a connection with my database:

function open_connection() {		$host='localhost:3307';		$user='any';		$db='my_db';		$password='my_pass';		$conn=mysql_connect($host,$user,$password);		mysql_create_db ($db,$conn);		mysql_select_db($db);	return $conn;}

If I call this function within my file I get the error:

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in
As far as i know you use the port 3306 when you want to connect to a MySql host, not to the port that you specify, in this case 3307, also, you don't need to specify this on your connection scripts. So, change it to 3306 or delete from your code.

Also, add to your code the mysql_error() function to check when you lost the connection and verify that in first case you get connected to the server:
function open_connection() {		$host='localhost';		$user='any';		$db='my_db';		$password='my_pass';		$conn=mysql_connect($host,$user,$password);		if (!$conn) {		  die('Could not connect: ' . mysql_error());		}		mysql_create_db ($db,$conn) or die('Could not connect: ' . mysql_error());		mysql_select_db($db);	return $conn;}

Another problem is that according to the PHP online manual the mysql_create_db() function is obsolete and recommends to use the mysql_query() function instead.

Best regards,

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.