大家小弟我快疯掉了，快来帮小弟我看下-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

大家小弟我快疯掉了，快来帮小弟我看下

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 am 10:18 AM

communicationconnectionmysqlreading

大家我快疯掉了，快来帮我看下
我在本地做的程序，连接数据库什么都一切正常，但是现在传到人家那空间上就报这样的错误，人家是linux系统，错误如下：
[size=13px][b]mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 [/b][/size]
大家看到希望能尽快帮我，不然我完蛋了，人家不要这个系统了，我就白做了，谢谢大家。

------解决方案--------------------
google一下。 http://www.dzhope.com/post/538/
------解决方案--------------------
先看数据库正常不表结构和你测试环境一样？
------解决方案--------------------
你数据库连接有问题

参考如下：

Debian下Mysql服务器远程连接时会出现：Lost connection to MySQL server at 'reading initial communication packet'的错误，用户权限已设置为允许任意主机连接。其实问题出在Mysql的配置上，在my.cnf里，有一条是bind-address=127.0.0.1，其含义是仅监听本地连接，将该条注释后重启Mysql服务即可顺利连接远程服务器。communication packet'的错误，用户权限已设置为允许任意主机连接。其实问题出在Mysql的配置上，在my.cnf里，有一条是bind-address=127.0.0.1，其含义是仅监听本地连接，将该条注释后重启Mysql服务即可顺利连接远程服务器。
------解决方案--------------------
你写个测试php 看数据库正常不正常
------解决方案--------------------
如果你改不了服务器，估计是没戏了。人家不让你远程链接
------解决方案--------------------
问下对方的空间商数据库连接的ip 帐号密码.按照空间商提供的参数修改你的配置文件.
------解决方案--------------------
多半是数据库服务器名写错了
你查阅一下在购买空间时供应商给你的文档

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

What is dependency injection in PHP?May 07, 2025 pm 03:09 PM

DependencyinjectioninPHPisadesignpatternthatenhancesflexibility,testability,andmaintainabilitybyprovidingexternaldependenciestoclasses.Itallowsforloosecoupling,easiertestingthroughmocking,andmodulardesign,butrequirescarefulstructuringtoavoidover-inje

Best PHP Performance Optimization TechniquesMay 07, 2025 pm 03:05 PM

PHP performance optimization can be achieved through the following steps: 1) use require_once or include_once on the top of the script to reduce the number of file loads; 2) use preprocessing statements and batch processing to reduce the number of database queries; 3) configure OPcache for opcode cache; 4) enable and configure PHP-FPM optimization process management; 5) use CDN to distribute static resources; 6) use Xdebug or Blackfire for code performance analysis; 7) select efficient data structures such as arrays; 8) write modular code for optimization execution.

PHP Performance Optimization: Using Opcode CachingMay 07, 2025 pm 02:49 PM

OpcodecachingsignificantlyimprovesPHPperformancebycachingcompiledcode,reducingserverloadandresponsetimes.1)ItstorescompiledPHPcodeinmemory,bypassingparsingandcompiling.2)UseOPcachebysettingparametersinphp.ini,likememoryconsumptionandscriptlimits.3)Ad

PHP Dependency Injection: Boost Code MaintainabilityMay 07, 2025 pm 02:37 PM

Dependency injection provides object dependencies through external injection in PHP, improving the maintainability and flexibility of the code. Its implementation methods include: 1. Constructor injection, 2. Set value injection, 3. Interface injection. Using dependency injection can decouple, improve testability and flexibility, but attention should be paid to the possibility of increasing complexity and performance overhead.

How to Implement Dependency Injection in PHPMay 07, 2025 pm 02:33 PM

Implementing dependency injection (DI) in PHP can be done by manual injection or using DI containers. 1) Manual injection passes dependencies through constructors, such as the UserService class injecting Logger. 2) Use DI containers to automatically manage dependencies, such as the Container class to manage Logger and UserService. Implementing DI can improve code flexibility and testability, but you need to pay attention to traps such as overinjection and service locator anti-mode.

What is the difference between unset() and session_destroy()?May 04, 2025 am 12:19 AM

Thedifferencebetweenunset()andsession_destroy()isthatunset()clearsspecificsessionvariableswhilekeepingthesessionactive,whereassession_destroy()terminatestheentiresession.1)Useunset()toremovespecificsessionvariableswithoutaffectingthesession'soveralls

What is sticky sessions (session affinity) in the context of load balancing?May 04, 2025 am 12:16 AM

Stickysessionsensureuserrequestsareroutedtothesameserverforsessiondataconsistency.1)SessionIdentificationassignsuserstoserversusingcookiesorURLmodifications.2)ConsistentRoutingdirectssubsequentrequeststothesameserver.3)LoadBalancingdistributesnewuser

What are the different session save handlers available in PHP?May 04, 2025 am 12:14 AM

PHPoffersvarioussessionsavehandlers:1)Files:Default,simplebutmaybottleneckonhigh-trafficsites.2)Memcached:High-performance,idealforspeed-criticalapplications.3)Redis:SimilartoMemcached,withaddedpersistence.4)Databases:Offerscontrol,usefulforintegrati

See all articles