SpringBoot+MyBatis+Mysql以及使用IDEA进行连接时遇到的坑

问题1 IDEA database工具无法连接Mysql

啥玩意儿？明明cmd窗口都能正常登录，怎么到IDEA这儿就不行了呢？

解决1

一波百度加上一波猜测，应该是连接的URL的问题。
在其后加上serverTimezone=GMT

jdbc:mysql://localhost:3306/idea_mysql?serverTimezone=GMT

即可。

问题2 所写Java程序无法访问Mysql

今天在用IDEA进行连接Mysql时发现，使用IDEA右侧的database连接时一切正常，可以正常进行增删查改，可是一但使用程序进行连接时就死活不行。访问网页后总是报错：

This application has no explicit mapping for /error, so you are seeing this as a fallback.
Wed Oct 23 19:23:53 CST 2019
There was an unexpected error (type=Internal Server Error, status=500).
nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES) ### The error may exist in top/hellooooo/community/mapper/UserMapper.java (best guess) ### The error may involve top.hellooooo.community.mapper.UserMapper.insert ### The error occurred while executing an update ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES)

登录台报错

java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES)

这就有点奇怪了，为啥@'localhost’前的username会是空的呢？

解决2

经过一番资料查阅以及不断的尝试之后，发现，原来是我敲得太快，被IDEA给带过去了。
原来的application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/idea_mysql?serverTimezone=GMT
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.name=root
spring.datasource.password=root

不应该是name，而应该是username
…
更改之后

spring.datasource.url=jdbc:mysql://localhost:3306/idea_mysql?serverTimezone=GMT
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=root

大功告成！