[乐意黎原创]MySQL抛Warning: PDO::query(): MySQL server has gone away in

怼烎@ 2022-05-22 11:23 225阅读 0赞

最近乐意黎在转移主机时(新主机: Centos 7 +php7+apache +mysql )，页面访问MySQL在抛错：  
Warning : PDO::query(): MySQL server has gone away in  /usr/local/apache/websites/index.php  on line  111  
  
Warning : PDO::query(): Error reading result set's header in  /usr/local/apache/websites/index.php  on line  111

Fatal error: Uncaught PDOException: SQLSTATE\[HY000\]: General error: 2006 MySQL server has gone away in /usr/local/apache/websites/index.php:111 Stack trace: \#0 /usr/local/apache/websites/index.php(111): PDO->query('SELECT \* FROM \`...') \#1 \{main\} thrown in /usr/local/apache/websites/index.php on line 111

解决办法：（应用时必须重启mysql数据库～～  systemctl restart mysqld ）

A . 在mysql配置文件/etc/my.cnf中添加或修改为以下配置：

\[mysqld\_safe\]  
log-error=/usr/local/mysql/logs/mysqld.log  
pid-file=/var/run/mysqld.pid

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\# time out  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
connect\_timeout = 20

wait\_timeout = 2880000  
interactive\_timeout = 2880000

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
\# connection  
\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#  
max\_connections = 2000  
max\_user\_connections = 1900  
max\_connect\_errors = 100000  
max\_allowed\_packet = 1G

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

当打开 \[mysqld\_safe\] 时，请执行以下操作

\[root@aerchi.com mysql\]\# mkdir logs

\[root@aerchi.com mysql\]\# echo "" > /usr/local/mysql/logs/mysqld.log  
\[root@aerchi.com mysql\]\# chown -R mysql:mysql /usr/local/mysql/logs/mysqld.log

**B. 修改 连接MySQL的php文件**

增加 PDO::ATTR\_PERSISTENT => false, PDO::MYSQL\_ATTR\_USE\_BUFFERED\_QUERY => true,

如下:

$PDO = @new PDO("mysql:host=$DB\_HOST;dbname=$DB\_NAME","$DB\_USER","$DB\_PASSWORD", array(PDO::ATTR\_PERSISTENT => false, PDO::MYSQL\_ATTR\_USE\_BUFFERED\_QUERY => true, PDO::MYSQL\_ATTR\_INIT\_COMMAND => "SET NAMES 'utf8';"));

**C. 修改 php.ini**  
vim  /etc/php.ini

mysqli.reconnect = Off

修改成:

mysqli.reconnect = On

乐意黎原创

2018-06-23 00:24