2021-08-0217:21:37.818 ERROR 8116---[reate-501036152]com.alibaba.druid.pool.DruidDataSource: create connection SQLException, url: jdbc:mysql://localhost:3306/study?useUnicode=true&characterEncoding=utf-8, errorCode 1044, state 42000java.sql.SQLSyntaxErrorException:Access denied for user 'user'@'localhost'todatabase'study'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)~[mysql-connector-java-8.0.25.jar:8.0.25]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)~[mysql-connector-java-8.0.25.jar:8.0.25]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833)~[mysql-connector-java-8.0.25.jar:8.0.25]
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453)~[mysql-connector-java-8.0.25.jar:8.0.25]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)~[mysql-connector-java-8.0.25.jar:8.0.25]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)~[mysql-connector-java-8.0.25.jar:8.0.25]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1652)~[druid-1.2.5.jar:1.2.5]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1718)~[druid-1.2.5.jar:1.2.5]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2792)~[druid-1.2.5.jar:1.2.5]
二、问题分析
主要问题出现在以下这句话中:
java.sql.SQLSyntaxErrorException:Access denied for user 'user'@'localhost'todatabase'study'