Lost connection to MySQL server at 'reading initial communication packet

Possible fix is to try to:
Edit this file : /etc/mysql/my.cnf
End comment (#) this line : bind-address = 127.0.0.1

See if it works.

However sometimes badly written mysql query codes can cause this, which is probably what is happening in bot.php or other include files executing under bot.php.

Check exactly what is on line 354...

nizsmo I have no mysql folder in /etc but I do have a my.cnf in .etc, this is what it contains:


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"


What would I change, if anything?

Also, here are the lines of code from 348-358:

$ircBot = bot::getInstance();
$ircBot->launch();
function m_q($query) {
      $host = 'domainname.net';
      $user = 'username';
      $pass = 'password';
      mysql_connect($host,$user,$pass);
      mysql_select_db('admin_bots');
      return mysql_query($query);
}
?>

Any help is appreciated.

Thanks, Brad

Add the line in the mysqld-section:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
bind-address = 127.0.0.1

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

Ok I added the line: bind-address = 127.0.0.1

Unfortunately still no luck. I should add that I'm trying to connect to a remote mysql server not on this box. Not sure if that matters.

Anyways, any other possible solutions?

Thanks, Brad

In this case restart the remote mysql-server and check if the problem still occures.

Unfortunately I still get the same error, any other iideas?

This should explain all: http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html