 Lost Connection To Mysql ,..., System Error: 111 In |
|
|
|
|
  |
 Feb 5 2008, 06:22 AM
Post
#1
|
|
|
Member [ Level 1 ]  Group: Members Posts: 48 Joined: 5-February 08 From: Japan Member No.: 28,155  |
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? This post has been edited by rockarolla: Feb 5 2008, 06:23 AM |
 |
 
|
|
Feb 5 2008, 09:48 AM
Post
#2
|
|
|
Way Out Of Control - You need a life :)  Group: [MODERATOR] Posts: 1,980 Joined: 16-August 05 Member No.: 7,896 |
If you can access your database through cpanel and PHPMyAdmin, it's not a server issue. So, the issue is inside your php program.
|
|
|
|
|
Feb 5 2008, 02:32 PM
Post
#3
|
|
|
Member [ Level 1 ] Group: Members Posts: 48 Joined: 5-February 08 From: Japan Member No.: 28,155 |
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. This post has been edited by rockarolla: Feb 5 2008, 02:34 PM |
|
|
|
|
Feb 6 2008, 10:25 AM
Post
#4
|
|
|
Super Member  Group: [HOSTED] Posts: 746 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 |
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, |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 5th September 2008 - 12:11 PM |