连接超时出现com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
(1)cmd输入mysql需要密码NO
C:\Program Files\MySQL\MySQL Server 5.5\my.ini里[mysqld]下添加skip-grant-tables
(2)cmd输入mysql输入以下内容查看wait_timeout和interactive_timeout
show global variables like 'wait_timeout';
show global variables like 'interactive_timeout';
(3)在C:\Program Files\MySQL\MySQL Server 5.5\my.ini里[mysqld]下添加
# this is myown dinifition for mysql connection timeout
wait_timeout=31536000
interactive_timeout=31536000
解决方法:
(1)cmd输入mysql需要密码NO
C:\Program Files\MySQL\MySQL Server 5.5\my.ini里[mysqld]下添加skip-grant-tables
(2)cmd输入mysql输入以下内容查看wait_timeout和interactive_timeout
show global variables like 'wait_timeout';
show global variables like 'interactive_timeout';
(3)在C:\Program Files\MySQL\MySQL Server 5.5\my.ini里[mysqld]下添加
# this is myown dinifition for mysql connection timeout
wait_timeout=31536000
interactive_timeout=31536000