[mysq]ERROR 2006 (HY000) at line xx: MySQL server has gone away 解决方法
2023-09-27 14:29:13 时间
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
相关文章
- MySQL进阶篇(02):索引体系划分,B-Tree结构说明
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- 如何选择最适合你的数据库解决方案:PostgreSQL VS MySQL 技术选型对比
- MySQL小工具 之 压测Groovy
- Mysql JDBC Url参数说明useUnicode=true&characterEncoding=UTF-8
- Mysql错误check the manual that corresponds to your MySQL server version for the right syntax
- 面试题:MySQL的原子性和持久性如何保证?
- Host is not allowed to connect to this MySQL server解决方法
- Mysql mysql lost connection to server during query 问题解决方法
- MySQL 数据库设计 笔记与总结(4)维护优化
- Host is not allowed to connect to this MySQL server解决方法
- com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 ‘DUAL‘ 无效 | Druid双数据源MySQL+SQL server
- pymysql 批量插入报错 MySQL server has gone away (BrokenPipeError(32, 'Broken pipe')
- MySQL Server8.0版本时出现Client does not support authentication protocol requested by server
- sql: MySQL and Microsoft SQL Server Stored Procedures IN, OUT using csharp code
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
- MySQL server has gone away
- 批量修改Mysql数据库表Innodb为MyISAN
- Oracle、SQL Server、MySQL分页方法
- mysql:1130 is not allowed to connect to this MariaDB server解决办法
- Navicat连接数据库出现 is not allowed to connect to this MySQL server 报错