Logo Questions Linux Laravel Mysql Ubuntu Git Menu

"Lost connection to MySQL server" when trying to connect to remote MySQL server

I am using Zend Framework to develop my application and I try to connect to a remote MySQL database in my LAN.

The database connection settings in Zend is as follows:

db.adapter     = PDO_MYSQL
db.params.host =
db.params.port = 3306

[LIVE:GENERAL] db.params.username = root db.params.password = ** db.params.dbname = djudd

[DEVELOPMENT:GENERAL] db.params.username = root db.params.password = ** db.params.dbname = stellarengine

I got the following error:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 111' in /usr/share/php/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /usr/share/php/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:host=192....', 'root', 'password', Array) #1 /usr/share/php/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /usr/share/php/Zend/Db/Adapter/Abstract.php(448): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /usr/share/php/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBEbny_c...', Array) #4 /usr/share/php/Zend/Db/Adapter/Pdo/Mysql.php(156): Zend_Db_Adapter_Pdo_Abstract->query('DESCRIBE bny_c...') #5 /usr/share/php/Zend/Db/Table/Abstract.php(823): Zend_Db_Adapter_Pdo_Mysql->describeTable('bny_core_module...', NULL) #6 /usr/share/php/Zend/Db/Table/Abstract.php(866): Zend_Db_Table_Abstract->_setupMetadata() #7 /usr/share/php/Zend/Db/Table/Abstract. in /usr/share/php/Zend/Db/Adapter/Pdo/Abstract.php on line 144

Please help me to resolve this problem.

like image 729
Karthikeyan Avatar asked Feb 26 '23 13:02


2 Answers

Last time I had this type of error, I had to change my host from: to 'localhost' and then it worked fine.

like image 157
pdolinaj Avatar answered Feb 28 '23 02:02


This might help: MySQL Forum: 'reading initial communication packet', system error: 111

like image 35
Srisa Avatar answered Feb 28 '23 04:02