vim /etc/mysql/mysql.conf.d/mysqld.cnf [mysqld]
#3600000/1000=3600秒=1小时
wait_timeout =3600000
#2G缓冲
max_allowed_packet =2048M service mysql restart
以上为ubuntu设置方法,mysql5.7.20-0ubuntu0.17.04.1
相关文章
- MySQL报错解决方案：2013-Lost connection to MySQL server
- MySQL 8.0版本连接报错：Could not create connection to database server.
- java项目连接jdbc报错：com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server
- MySQL远程连接丢失问题解决方法（Lost connection to MySQL server）
- 虚拟机中MySQL连接问题：Lost connection to MySQL server at 'reading initial communication packet, system error: 0 以及 host is not allowed to connect mysql
- lost connection to mysql server at "reading initial communication packet",system error:2
- Lost connection to MySQL server at 'reading initial communication packet', system error: 0的一个解决方案
- mysql远程连接问题 Lost connection to MySQL server at ‘reading initial communication packet', system error: 0
- mysql登陆时出现ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
- Mysql Lost connection to MySQL server at ‘reading initial communication packet', system error: 0