tomcat访问一直转圈,无法访问,关键还没有报错,看到这个就有点摸不清头脑,不过我聪明,用mybatis的log4j打印日志,需要的自己看官网哈地址
然后就是看报错信息了
1
、数据源未加jdbc作为前缀,这个有点无语,无语自己
ERROR [Druid-ConnectionPool-Create-1838282273] - create connection SQLException, url: jdbc:mysql://localhost:3306/green?serverTimezone=UTC, errorCode 1045, state 28000
java.sql.SQLException: Access denied for user ‘Administrator’@‘localhost’ (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
at com.alibaba.druid.pool.DruidDataSource
C
r
e
a
t
e
C
o
n
n
e
c
t
i
o
n
T
h
r
e
a
d
.
r
u
n
(
D
r
u
i
d
D
a
t
a
S
o
u
r
c
e
.
j
a
v
a
:
2753
)
E
R
R
O
R
[
D
r
u
i
d
−
C
o
n
n
e
c
t
i
o
n
P
o
o
l
−
C
r
e
a
t
e
−
1838282273
]
−
c
r
e
a
t
e
c
o
n
n
e
c
t
i
o
n
S
Q
L
E
x
c
e
p
t
i
o
n
,
u
r
l
:
j
d
b
c
:
m
y
s
q
l
:
/
/
l
o
c
a
l
h
o
s
t
:
3306
/
g
r
e
e
n
?
s
e
r
v
e
r
T
i
m
e
z
o
n
e
=
U
T
C
,
e
r
r
o
r
C
o
d
e
1045
,
s
t
a
t
e
28000
j
a
v
a
.
s
q
l
.
S
Q
L
E
x
c
e
p
t
i
o
n
:
A
c
c
e
s
s
d
e
n
i
e
d
f
o
r
u
s
e
r
′
A
d
m
i
n
i
s
t
r
a
t
o
r
′
@
′
l
o
c
a
l
h
o
s
t
′
(
u
s
i
n
g
p
a
s
s
w
o
r
d
:
Y
E
S
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
e
x
c
e
p
t
i
o
n
s
.
S
Q
L
E
r
r
o
r
.
c
r
e
a
t
e
S
Q
L
E
x
c
e
p
t
i
o
n
(
S
Q
L
E
r
r
o
r
.
j
a
v
a
:
129
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
e
x
c
e
p
t
i
o
n
s
.
S
Q
L
E
r
r
o
r
.
c
r
e
a
t
e
S
Q
L
E
x
c
e
p
t
i
o
n
(
S
Q
L
E
r
r
o
r
.
j
a
v
a
:
97
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
e
x
c
e
p
t
i
o
n
s
.
S
Q
L
E
x
c
e
p
t
i
o
n
s
M
a
p
p
i
n
g
.
t
r
a
n
s
l
a
t
e
E
x
c
e
p
t
i
o
n
(
S
Q
L
E
x
c
e
p
t
i
o
n
s
M
a
p
p
i
n
g
.
j
a
v
a
:
122
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
C
o
n
n
e
c
t
i
o
n
I
m
p
l
.
c
r
e
a
t
e
N
e
w
I
O
(
C
o
n
n
e
c
t
i
o
n
I
m
p
l
.
j
a
v
a
:
836
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
C
o
n
n
e
c
t
i
o
n
I
m
p
l
.
<
i
n
i
t
>
(
C
o
n
n
e
c
t
i
o
n
I
m
p
l
.
j
a
v
a
:
456
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
C
o
n
n
e
c
t
i
o
n
I
m
p
l
.
g
e
t
I
n
s
t
a
n
c
e
(
C
o
n
n
e
c
t
i
o
n
I
m
p
l
.
j
a
v
a
:
246
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
N
o
n
R
e
g
i
s
t
e
r
i
n
g
D
r
i
v
e
r
.
c
o
n
n
e
c
t
(
N
o
n
R
e
g
i
s
t
e
r
i
n
g
D
r
i
v
e
r
.
j
a
v
a
:
197
)
a
t
c
o
m
.
a
l
i
b
a
b
a
.
d
r
u
i
d
.
p
o
o
l
.
D
r
u
i
d
A
b
s
t
r
a
c
t
D
a
t
a
S
o
u
r
c
e
.
c
r
e
a
t
e
P
h
y
s
i
c
a
l
C
o
n
n
e
c
t
i
o
n
(
D
r
u
i
d
A
b
s
t
r
a
c
t
D
a
t
a
S
o
u
r
c
e
.
j
a
v
a
:
1644
)
a
t
c
o
m
.
a
l
i
b
a
b
a
.
d
r
u
i
d
.
p
o
o
l
.
D
r
u
i
d
A
b
s
t
r
a
c
t
D
a
t
a
S
o
u
r
c
e
.
c
r
e
a
t
e
P
h
y
s
i
c
a
l
C
o
n
n
e
c
t
i
o
n
(
D
r
u
i
d
A
b
s
t
r
a
c
t
D
a
t
a
S
o
u
r
c
e
.
j
a
v
a
:
1710
)
a
t
c
o
m
.
a
l
i
b
a
b
a
.
d
r
u
i
d
.
p
o
o
l
.
D
r
u
i
d
D
a
t
a
S
o
u
r
c
e
CreateConnectionThread.run(DruidDataSource.java:2753) ERROR [Druid-ConnectionPool-Create-1838282273] - create connection SQLException, url: jdbc:mysql://localhost:3306/green?serverTimezone=UTC, errorCode 1045, state 28000 java.sql.SQLException: Access denied for user 'Administrator'@'localhost' (using password: YES) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710) at com.alibaba.druid.pool.DruidDataSource
CreateConnectionThread.run(DruidDataSource.java:2753)ERROR[Druid−ConnectionPool−Create−1838282273]−createconnectionSQLException,url:jdbc:mysql://localhost:3306/green?serverTimezone=UTC,errorCode1045,state28000java.sql.SQLException:Accessdeniedforuser′Administrator′@′localhost′(usingpassword:YES)atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)atcom.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)atcom.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)atcom.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)atcom.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)atcom.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)atcom.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)atcom.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)atcom.alibaba.druid.pool.DruidDataSourceCreateConnectionThread.run(DruidDataSource.java:2753)
这个原因其实就是如果数据源前缀不加jdbc或者其他,又刚好用了root,就会报错,因为这个访问了你电脑,当然也可以不是root,因为你电脑上的用户名太多了,所以还是加上。,
2
、这个“?serverTimezone=UTC
”是时区错误,具体自己百度啦,反正mysql8.0.12以上,url后缀加上“?serverTimezone=UTC”
ERROR [Druid-ConnectionPool-Create-1785276956] - create connection SQLException, url: jdbc:mysql://localhost:3306/green, errorCode 0, state 01S00
java.sql.SQLException: The server time zone value ‘?й???’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the ‘serverTimezone’ configuration property) to use a more specifc time zone value if you want to utilize time zone support.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2753)
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value ‘?й???’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the ‘serverTimezone’ configuration property) to use a more specifc time zone value if you want to utilize time zone support.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2118)
at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2142)
at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1310)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:967)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:826)
… 6 more