错误HikariPool-1 - Exception during..+ Access denied for user ‘root‘@‘localhost‘ (using password: YES)

已于 2022-04-03 11:24:00 修改
阅读量3.8k 收藏 3
点赞数 2
分类专栏： Error 文章标签： idea mysql
于 2022-04-03 11:02:22 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/A_Axiaobai/article/details/123931789
版权

项目场景：

前些天在IDEA中导入项目后，更改好配置，运行出错

问题描述

以下是错误提示：

ERROR 18660 --- [3)-192.168.48.1] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) [HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) [HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-3.2.0.jar:na]
	at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157) [spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) [spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) [spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:323) [spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.getProduct(DataSourceHealthIndicator.java:119) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doDataSourceHealthCheck(DataSourceHealthIndicator.java:107) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doHealthCheck(DataSourceHealthIndicator.java:102) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.health.AbstractHealthIndicator.health(AbstractHealthIndicator.java:82) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.health.CompositeHealthIndicator.health(CompositeHealthIndicator.java:95) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.health.HealthEndpoint.health(HealthEndpoint.java:50) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_322]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_322]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_322]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_322]
	at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:282) [spring-core-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.boot.actuate.endpoint.invoke.reflect.ReflectiveOperationInvoker.invoke(ReflectiveOperationInvoker.java:76) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.endpoint.annotation.AbstractDiscoveredOperation.invoke(AbstractDiscoveredOperation.java:60) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.endpoint.jmx.EndpointMBean.invoke(EndpointMBean.java:121) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.endpoint.jmx.EndpointMBean.invoke(EndpointMBean.java:96) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) [na:1.8.0_322]
	at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801) [na:1.8.0_322]
	at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468) [na:1.8.0_322]
	at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76) [na:1.8.0_322]
	at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309) [na:1.8.0_322]
	at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1401) [na:1.8.0_322]
	at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829) [na:1.8.0_322]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_322]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_322]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_322]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_322]
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357) [na:1.8.0_322]
	at sun.rmi.transport.Transport$1.run(Transport.java:200) [na:1.8.0_322]
	at sun.rmi.transport.Transport$1.run(Transport.java:197) [na:1.8.0_322]
	at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0_322]
	at sun.rmi.transport.Transport.serviceCall(Transport.java:196) [na:1.8.0_322]
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573) [na:1.8.0_322]
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834) [na:1.8.0_322]
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688) [na:1.8.0_322]
	at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0_322]
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687) [na:1.8.0_322]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_322]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_322]
	at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_322]

WARN 18660 --- [3)-192.168.48.1] o.s.b.a.jdbc.DataSourceHealthIndicator   : DataSource health check failed

org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ~[spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:323) ~[spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.getProduct(DataSourceHealthIndicator.java:119) ~[spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doDataSourceHealthCheck(DataSourceHealthIndicator.java:107) ~[spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doHealthCheck(DataSourceHealthIndicator.java:102) ~[spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.health.AbstractHealthIndicator.health(AbstractHealthIndicator.java:82) ~[spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.health.CompositeHealthIndicator.health(CompositeHealthIndicator.java:95) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.health.HealthEndpoint.health(HealthEndpoint.java:50) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_322]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_322]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_322]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_322]
	at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:282) [spring-core-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.boot.actuate.endpoint.invoke.reflect.ReflectiveOperationInvoker.invoke(ReflectiveOperationInvoker.java:76) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.endpoint.annotation.AbstractDiscoveredOperation.invoke(AbstractDiscoveredOperation.java:60) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.endpoint.jmx.EndpointMBean.invoke(EndpointMBean.java:121) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at org.springframework.boot.actuate.endpoint.jmx.EndpointMBean.invoke(EndpointMBean.java:96) [spring-boot-actuator-2.1.6.RELEASE.jar:2.1.6.RELEASE]
	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819) [na:1.8.0_322]
	at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801) [na:1.8.0_322]
	at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1468) [na:1.8.0_322]
	at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76) [na:1.8.0_322]
	at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1309) [na:1.8.0_322]
	at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1401) [na:1.8.0_322]
	at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:829) [na:1.8.0_322]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_322]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_322]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_322]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_322]
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357) [na:1.8.0_322]
	at sun.rmi.transport.Transport$1.run(Transport.java:200) [na:1.8.0_322]
	at sun.rmi.transport.Transport$1.run(Transport.java:197) [na:1.8.0_322]
	at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0_322]
	at sun.rmi.transport.Transport.serviceCall(Transport.java:196) [na:1.8.0_322]
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573) [na:1.8.0_322]
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834) [na:1.8.0_322]
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688) [na:1.8.0_322]
	at java.security.AccessController.doPrivileged(Native Method) [na:1.8.0_322]
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687) [na:1.8.0_322]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_322]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_322]
	at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_322]
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) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~[mysql-connector-java-8.0.16.jar:8.0.16]
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-3.2.0.jar:na]
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) ~[HikariCP-3.2.0.jar:na]
	at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157) ~[spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) ~[spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) ~[spring-jdbc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
	... 40 common frames omitted

原因分析：

1、MySQL配置是否正确
2、驱动包是否匹配
3、是否有多个mysql进程服务开启

我是很确定前两项我这都没问题
yml配置文件中数据库配置信息及驱动包版本
在这里插入图片描述
数据库用户及密码
在这里插入图片描述
数据库的基本配置及MySQL版本
在这里插入图片描述
经过检查，我这出现这个问题并不是yml配置和数据库的问题，我用navicat是可以连接上的。

那么就看看第3点了，打开任务管理器
在这里插入图片描述
可以看到有两种版本的mysql在运行，那么问题就出在这了。

解决方案：

这里的mysqlzt是禅道的mysql数据库服务

将不需要的mysql进程及服务结束就可以了
在这里插入图片描述
重新运行项目就成功了。

注：此文仅描述本人所遇问题及解决方案。有类似问题的朋友，此文提供的解决方案仅供参考。

参考博客：
①：The specified database user/password combination is rejected: [28000][1045] Access denied for user ‘
②：SpringBoot启动报错：HikariPool-1 - Exception during pool initialization.
③：MySQL登录时出现Access denied for user ‘root‘@‘localhost‘ (using password: YES)无法打开的解决方法
④：解决Mysql 的Access denied for user’root’@‘localhost’ (using password: NO)问题

A_Axiaobai
关注
  • 2
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
HikariPool使用MySQL/MariaDB数据库报错解决：java.sql.SQLException: Access denied for user 'root'@'localhost' (u
个人博客
06-25 2757
在使用HikariPool连接到我的数据库时报错如下，完整的报错放在最后： 2019-06-25 20:24:26.048 ERROR 18204 --- [nio-8080-exec-9] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization. java.sq...
springboot启动报错com.zaxxer.hikari.pool.HikariPool : root - Exception during pool initialization.
ljj123_的博客
07-12 1万+
springboot启动时报错com.zaxxer.hikari.pool.HikariPool : root - Exception during pool initialization. 改为如下配置后，启动成功 server.port=8080 spring.application.name=server_edu spring.profiles.active=dev spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver .
关于java后端jdbc报错：（ com.zaxxer.hikari.pool.HikariPool: HikariPool-1 - Exception during pool initial）问题
最新发布
weixin_67272154的博客
04-20 969
这样就解决HikariPool-1 - Exception during pool initial报错问题了。这个异常主要是说这个HikariPool没能完成初始化，但造成这一结果的原因有很多。
SpringBoot项目启动报错：HikariPool-1 - Exception during pool initialization
G_x_n的博客
02-24 4618
0. SpringBoot项目启动报错 HikariPool-1 - Exception during pool initialization 意思：HikariPool连接池初始化的时候出现异常 1. 报错信息 HikariPool-1 - Exception during pool initialization. com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure at com.mys
HikariPool-1 - Exception during pool initialization.的解决方法
LYly_B的博客
04-13 2万+
HikariPool-1 - Exception during pool initialization.的解决方法。 HikariPool-1-池初始化期间出现异常。 1.在application.properties中的spring.datasource.url后增加一个&useSSL=false&serverTimezone=UTC。 #配置数据源 spring.datas...
HikariPool-1 - Exception during pool initialization.java.sql.SQLSyntaxErrorException: Unknown databa
weixin_63198236的博客
11-27 762
检查数据库用户名和密码均正确。尝试在application.properties中的spring.datasource.url后增加参数，没有解决。cmd输入services.msc，回车进入服务。关闭图中的mysqlzt服务，重启项目，问题解决。mysql服务冲突。
解决 HikariPool-1 - Exception during pool initialization.问题
qq_40369243的博客
04-18 4620
HikariPool-1 - Exception during pool initialization.java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed 在mysql8.0以上的版本，在连接数据库的时候报错： HikariPool-1 - Exception during pool initialization.java.sql.SQLNonTransientConnectionExc...
com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.
热门推荐
wowYuXuan808的博客
04-20 4万+
mysql连接失败HikariPool错误 这个异常主要是说这个什么HikariPool鬼东西没能完成初始化，但造成这一结果的原因有很多。 可能是 1.驱动问题， 比如版本问题（例如：mysql的版本高于驱动的版本，统一使用8以上的驱动就能解决，8版驱动向下兼容；或例如缺乏依赖导入，比如本地已有不再扫描等等属于普通依赖配置问题， <scope>runtime</scope>...
springboot项目运行时报错：HikariPool-1 - Exception during pool initialization.
二哈喇子！
01-28 1万+
springboot项目运行时报错了？ SpringBoot启动失败Application run failed的解决办法
mysql Access denied for user ‘root’@’localhost’ (using password: YES)解决方法
09-10
主要介绍了mysql Access denied for user ‘root’@’localhost’ (using password: YES)解决方法,本文给出详细的解决步骤及操作注释,需要的朋友可以参考下
记录因为yml而产生的坑：java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
01-19
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) 提示的是用户访问被拒绝，原因是密码不正确，但是我们明明配置的是正确的密码，原因就在yml中： spring: datasource: ...
Linux连接mysql报错：Access denied for user ‘root’@‘localhost’(using password: YES)的解决方法
09-09
在Linux环境中，当你尝试使用`mysql`命令连接到MySQL数据库时，可能会遇到“Access denied for user 'root'@'localhost' (using password: YES)”的错误。这个错误通常表示你的MySQL服务器拒绝了你的登录尝试，可能...
ERROR 1045 (28000): Access denied for user ”root”@”localhost” (using password: YES)实用解决方案
12-15
在使用MySQL数据库时，有时会出现一个常见的错误：`ERROR 1045 (28000): Access denied for user "root"@"localhost" (using password: YES)`。这个错误表明，你尝试用root用户登录MySQL，但系统拒绝了你的访问，...
win10下MySQL 8.0登录Access denied for user‘root’@‘localhost’ (using password: YES)问题的解决方法
12-16
Access denied for user 'root'@'localhost' (using password: YES) 在网上找了很多解决办法，但是基本只有一个，在.ini文件中的mysqld条目添加 skip-grant-tables 然后重启服务器，再按照刚刚的步骤再来一遍（最后...
SpringBoot启动发生异常：HikariPool-1 - Exception during pool initialization
CharlesYooSky的博客
05-20 4221
新搭建的项目启动时候报错,如下： HikariPool-1 - Exception during pool initialization. java.sql.SQLNonTransien 这是由于springboot自带 mysql-connector-java版本过高，导致连接失败，最终导致连接池启动失败， 我们使用springboot版本是 <spring-boot.version>2.1.4.RELEASE</spring-boot.version> 数据库版本当然也会很
spring boo配置JDBC连接MySQL报错：unknown system variable、HikariPool-1-Exception during pool initialization
weixin_48889926的博客
11-09 435
一、 tx_isolation：mysql版本与mysql驱动器版本不一致 1、使版本一致 <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.22</version> //版本需匹配 </dependency> 2、注意 spring.datasou
Spring boot启动报错：HikariPool-1 - Exception during pool initialization.的两个解决方法
weixin_42421905的博客
01-10 8132
** 出现问题： ** 关于sql的 HikariPool-1 - Exception during pool initialization. 解决方法：如果用的是SpringBoot 2.0以上版本，应配置为driver‐class‐name: com.mysql.cj.jdbc.Driver org.springframework.jdbc.CannotGetJdbcConnectionException: jdbc链接异常 解决方法：在配置文件appliction-dev.yml文件中修改 spr.
SpringBoot启动报错：HikariPool-1 - Exception during pool initialization.解决办法
weixin_51735114的博客
10-27 6881
SpringBoot启动报错：HikariPool-1 - Exception during pool initialization.这里写自定义目录标题记一次Maven项目部署http访问mysql数据库过程中的问题首先确认你的Mysql数据库版本![Windows键输入mysql即可查看](https://img-blog.csdnimg.cn/1b57e9d6e39f4c5ebded825f7addf6ba.png?x-oss-process=image/watermark,type_ZHJvaWRz
[问题] springboot2报错 Exception during pool initialization. java.sql.SQLException
qq_44630167的博客
07-29 1159
用springboot配置文件连接数据库： yaml配置如下 报错类型： 2021-07-29 15:53:01.153 ERROR 12240 — [ restartedMain] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization. java.sql.SQLException: Access denied for user ‘root’@‘localhost’
java.sql.SQLException: Access denied for user root@localhost (using password: YES)
12-27
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) 是一个常见的数据库连接错误，表示用户'root'在本地主机上使用了错误的密码进行连接。 解决这个问题的方法有以下几种： 1. 确保用户名和密码正确：首先，确保你使用的用户名和密码是正确的。检查你的数据库配置文件或者数据库管理工具中的用户名和密码是否与你尝试连接的数据库一致。 2. 检查数据库权限：如果用户名和密码是正确的，但仍然无法连接数据库，可能是因为该用户没有足够的权限访问数据库。请确保该用户具有正确的权限，包括连接数据库和执行所需的操作。 3. 检查数据库连接字符串：检查你的数据库连接字符串是否正确。确保连接字符串中的用户名、密码和数据库名称都是正确的。 4. 检查数据库服务器配置：如果以上方法都没有解决问题，可能是因为数据库服务器的配置有问题。请检查数据库服务器的配置文件，确保允许远程连接，并且没有其他限制。 5. 检查防火墙设置：有时候，防火墙设置可能会阻止数据库连接。请确保你的防火墙允许数据库连接。 6. 重置密码：如果你确信用户名和密码是正确的，但仍然无法连接数据库，可以尝试重置密码。使用数据库管理工具或者命令行工具重置密码，并更新你的应用程序中的连接信息。 这些方法应该能够帮助你解决java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)错误。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值