# Mysql 常见报错

Mysql 常见报错

Mysql时区报错

• 报错信息：

The server time zone value ' й   ׼ʱ  ' is unrecognized or represents more than one time zone.（时区报错）

• 解决方法：设置Mysql的时区：set global time_zone = '+8:00';

Url 设置时区

jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8&serverTimezone=Asia/Shanghai

链接不可用

• 报错信息：

The last packet successfully received from the server was 870,513 milliseconds ago.  The last packet sent successfully to the server was 870,544 milliseconds ago.
is longer than the server configured value of 'wait_timeout'. 
You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts,
or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

• 解决办法：

show  variables like '%timeout%';
set  wait_timeout=1200;

---

Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

• 错误描述：在创建表结构时有且只有一个可以在default或者update时带上CURRENT_TIMESTAMP

• 解决办法：只让一个TIMESTAMP列在设置默认值或更新时带上CURRENT_TIMESTAMP