mysql常见错误

• 错误1：Establishing SSL connection without server's identity verification is not recommend

# 解决方案：在连接MySQL的url中添加如下：
url=jdbc:mysql://127.0.0.1:3306/framework?characterEncoding=utf8&useSSL=true

• 错误2：com.mysql.jdbc.exceptions.jdbc4.CommunicationsExcepti：Communications link failure

# 解决方案1：将useSSL = true改为false

# 解决方案2：更换jdbc驱动、指定时区、pom.xml中使用8.0以上的mysql驱动
driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.21</version>
</dependency>

• 错误3：java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

# 错误原因：连接mysql的密码错误

• 报错5：com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'test'

# 错误原因：连接mysql数据库时，没有找到对应的数据库