mysql数据库连接超过8小时失效的解决方案(springboot)
1.https://blog.csdn.net/chenyiming2010/article/details/90443418
2.https://blog.csdn.net/u012859681/article/details/62051509
3.修改mysql等待时长
mysql -h10.0.0.1 -uroot -p 打开MySQL的控制台, 运行: show variables like '%timeout%'; show global variables like 'wait_timeout'; #修改mysql等待时间24h set global wait_timeout=86400; set global interactive_timeout=86400; #重启mysql service mysqld restart #查看mysql等待时长 show global variables like 'wait_timeout'; show variables like '%timeout%'; show processlist;
posted on 2020-02-11 10:48 Steven5007 阅读(835) 评论(0) 编辑 收藏 举报