随笔分类 -  mysql

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 152,219,305 milliseconds ago.
摘要:com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 152,219,305 milliseconds ago. 阅读全文

posted @ 2013-12-21 12:20 下一行code 阅读(1921) 评论(0) 推荐(0)

Linux下mysql修改连接超时(windows下也适用)
摘要:首先进入mysql,查看 wait_timeout、interactive_timeout这个值是否为默认的8小时(即 28800)[root@server110 ~]# mysql -u root -pEnter password:输密码进入执行如下命令show variables like '%timeout%';+----------------------------+-------+| Variable_name | Value |+----------------------------+-------+| connect_timeout | 10 || d... 阅读全文

posted @ 2013-12-13 16:13 下一行code 阅读(717) 评论(0) 推荐(0)

修改mysql允许远程连接
摘要:use mysqlshow tables;mysql>select host from user;+-----------------------+| host |+-----------------------+| 127.0.0.1 || localhost || localhost || localhost.localdomain || localhost.localdomain |+-----------------------+5 rows in set (0.00 sec)mysql>update user set host='%... 阅读全文

posted @ 2013-12-07 20:44 下一行code 阅读(170) 评论(0) 推荐(0)

导航