java mysql问题汇总

Q:

java.lang.IllegalArgumentException: “Host ‘XXX’ is not allowed to connect to this MySQL server”

A:

step 1:修改mysql.user表
update mysql.user set Host=’%’ where user=‘root’

step 2:授权并刷新权限
GRANT ALL ON . TO ‘root’@’%’;
flush privileges;

Q:

java.sql.SQLException: The server time zone value

A:

连接串中增加serverTimezone=UTC