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

rockarolla

Feb 5 2008, 06:22 AM

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 in

Has 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?

Reply

yordan

Feb 5 2008, 09:48 AM

If you can access your database through cpanel and PHPMyAdmin, it's not a server issue. So, the issue is inside your php program.

Reply

rockarolla

Feb 5 2008, 02:32 PM

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:

CODE

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:

CODE

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.

Reply

TavoxPeru

Feb 6 2008, 10:25 AM

QUOTE(rockarolla @ Feb 5 2008, 09:32 AM)

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:

CODE

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:

CODE

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,

Reply

ADD REPLY / Got an Opinion!	a humble request :-)	RAPID SEARCH!	Free Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE