一个专业运
维技术分享!

[mysq]ERROR 2006 (HY000) at line xx: MySQL server has gone away 解决方法

vi /etc/my.cnf

wait_timeout=2880000
interactive_timeout = 2880000
max_allowed_packet = 100M

完整配置文件

[mysqld]

#init_connect='SET collation_connection = utf8_unicode_ci'

#init_connect='SET NAMES utf8'

#character-set-server=utf8

#collation-server=utf8_unicode_ci

#skip-character-set-client-handshake

wait_timeout=2880000

interactive_timeout = 2880000

max_allowed_packet = 100M



[client]

#default-character-set=utf8



[mysql]

#default-character-set=utf8




[mysqld_safe]

log-error=/var/log/mariadb/mariadb.log

#pid-file=/var/run/mariadb/mariadb.pid



#

# include all files from the config directory

#

!includedir /etc/my.cnf.d
赞(0) 打赏
本站资源仅供个人学习交流,请于下载后24小时内删除,不允许用于商业用途,否则法律问题自行承担。小柳实验室 » [mysq]ERROR 2006 (HY000) at line xx: MySQL server has gone away 解决方法

评论 抢沙发

评论前必须登录!

 

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏