com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'springdatajpa'

青旅半醒 2022-05-14 09:54 193阅读 0赞

今天启动springboot服务，突然出现

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'springdatajpa'
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_181]
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_181]
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_181]
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_181]
    ... 
    	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710) ~[mysql-connector-java-5.1.45.jar:5.1.45]
    	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226) ~[mysql-connector-java-5.1.45.jar:5.1.45]
    	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188) ~[mysql-connector-java-5.1.45.jar:5.1.45]
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219) ~[mysql-connector-java-5.1.45.jar:5.1.45]
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014) ~[mysql-connector-java-5.1.45.jar:5.1.45]
    	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776) ~[mysql-connector-java-5.1.45.jar:5.1.45]
    ...
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_181]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_181]
    	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) ~[spring-boot-devtools-2.0.0.RELEASE.jar:2.0.0.RELEASE]

异常信息过多，截取部分出来，关键部分

**com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'springdatajpa'**

检查后，发现，原来是mysql数据库重新安装了，springdatajpa 这个数据库名称没有创建。

创建数据库名称

mysql>  create database springdatajpa DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    Query OK, 1 row affected (0.02 sec)
    
    mysql>

再次启动springboot，成功起起来。

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'springdatajpa'

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘CLASSIN‘ in ‘field list‘

相关 mysql驱动引起的jdbc4.MySQLSyntaxErrorException: Unknown character set: ‘utf8mb4‘问题解决

相关 java.sql.SQLSyntaxErrorException: Unknown database

相关 ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You

相关 Unknown database ‘mybatis_plus‘

相关启动报错 -> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown database 'shouyuan'

相关 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'springdatajpa'

相关 jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘??????‘ in ‘field list‘

相关解决Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column XXX

相关 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database '/b2c_aiyou' 的解决办法