Access denied for user 'root'@'localhost' (using password: YES)
首先引入依赖
<!--引入spring boot-mybatis依赖 其中包含了mybatis依赖-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.0</version>
</dependency>
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper</artifactId>
<version>4.1.5</version>
</dependency>
<!-- 引入数据源-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.22</version>
</dependency>
<!-- 引入数据驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- 引入lombik 自动设置get和set无参构造-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
<scope>provided</scope>
</dependency>
在applications.yml进行配置
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/sys?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false
username: root
password: "0313" #密码是数字需要加引号
type: com.alibaba.druid.pool.DruidDataSource
mybatis:
mapper-locations: classpath:ems/mapper/*.xml #mapper配置文件的位置
type-aliases-package: com.demo.entity
出现errorCode 1045, state 28000错误是因为密码没有加引号才导致的前提确保密码正确并能且mysql已经启动,如果没有启动需要使用管理权限的cmd进行启动 命令为:net start mysql