“到MySQL服务器的丢失连接"尝试连接到远程MySQL服务器时 [英] "Lost connection to MySQL server" when trying to connect to remote MySQL server

问题描述

我正在使用Zend Framework开发应用程序，并尝试连接到LAN中的远程MySQL数据库.

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

Zend中的数据库连接设置如下:

[一般的]
db.adapter = PDO_MYSQL
db.params.host = 192.168.1.2
db.params.port = 3306 

The database connection settings in Zend is as follows:
[GENERAL]
db.adapter     = PDO_MYSQL
db.params.host = 192.168.1.2
db.params.port = 3306

 [LIVE:GENERAL]
db.params.username = root
db.params.password =   *  * 
db.params.dbname = djudd 
[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 
[DEVELOPMENT:GENERAL]
db.params.username = root
db.params.password = **
db.params.dbname   = stellarengine
 
我遇到以下错误:

  

    

      
 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('DESCRIBE bny_c ...'，数组)#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 
    

      
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 

  


请帮助我解决此问题.
推荐答案
上次出现此类错误时，我不得不将主机从: 127.0.0.1 更改为" localhost" "，然后效果很好.
Last time I had this type of error, I had to change my host from: 127.0.0.1 to 'localhost' and then it worked fine.

                        
这篇关于“到MySQL服务器的丢失连接"尝试连接到远程MySQL服务器时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！