之前一直能正常运行项目一直提示Unknown database ‘bills‘ ！重新搭建数据库提示Access denied for user ‘root‘@‘localhost‘

前言：

之前本地使用springboot+mybatisplus+mysql写的项目都能正常运行，但今天跑起来一直提示找不到数据库,用navcat以及本地cmd都能正常登陆操作Mysql。检查了半天，还是找不到问题，重装数据库之后还是提示同样的错误。

问题描述：

Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
	at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:158)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:116)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
	... 91 more

重新搭了数据库之后，提示密码不对，可navcat以及cmd控制台都能通过该密码成功登录。怀疑老版是不是数据库没删干净，项目指向了老的数据库。

原因分析：

通过查看window对应的服务，发现window服务确实对应了两个mysql服务，mysql和mysqlzt：

解决方案：

将window服务中的mysqlzt停止运行，重启项目就正常运行起来了，完美的解决了这个问题。这个mysqlzt是最近在本机上搭建禅道时对应创建的数据库的服务。以后碰到类似问题时可以检查下是不是数据库服务冲突导致的。

2021-08-27 16:38:02.187  INFO 14404 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2021-08-27 16:38:02.336  INFO 14404 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2021-08-27 16:38:02.342 DEBUG 14404 --- [           main] c.e.m.s.m.ProviderMapper.selectList      : ==>  Preparing: SELECT pid,provider_code,provider_name,people,phone,address,fax,represent,create_date FROM provider
2021-08-27 16:38:02.363 DEBUG 14404 --- [           main] c.e.m.s.m.ProviderMapper.selectList      : ==> Parameters: 
2021-08-27 16:38:02.385 DEBUG 14404 --- [           main] c.e.m.s.m.ProviderMapper.selectList      : <==      Total: 5
Provider(pid=1, providerCode=P_111, providerName=A货云服务供应商11, people=小码, phone=1888888888, address=广州白云区, fax=020-123456, represent=专业ESC服务商, createDate=2018-11-17T12:21:54)
Provider(pid=2, providerCode=P_222, providerName=B货域名供应商, people=小域, phone=1888886666, address=北京朝阳区, fax=020-112312123, represent=专业提供域名, createDate=2018-11-17T12:14:53)
Provider(pid=3, providerCode=P_333, providerName=B货小程序企鹅, people=小企鹅, phone=1888666666, address=深圳南山区, fax=020-123123, represent=专业小程序提供, createDate=2028-11-12T11:52:17)
Provider(pid=4, providerCode=P_444, providerName=其他渠道供应商, people=无名, phone=1888999999, address=北京, fax=010-1000, represent=专业渠道来源, createDate=2018-11-12T12:07:02)
Provider(pid=6, providerCode=P_555, providerName=梦学谷供应商111, people=小张, phone=18888666981, address=深圳软件园, fax=0911-0123456, represent=品质Aaa, createDate=2018-11-17T12:23:12)