SpringBoot启动报错java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)

最新推荐文章于 2023-09-19 13:38:31 发布
最新推荐文章于 2023-09-19 13:38:31 发布
阅读量1.2k 收藏
点赞数 5
分类专栏： JAVA Spring 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44150474/article/details/107547595
版权
JAVA 同时被 3 个专栏收录
12 篇文章 0 订阅
订阅专栏
Spring
7 篇文章 0 订阅
订阅专栏
数据库
5 篇文章 1 订阅
订阅专栏

今天写了个springboot项目，结果启动报错，当时的数据库连接是这样配置的：
在这里插入图片描述
然后就报以下错误，后来发现将password加上双引号以后就可以正常启动了。
在这里插入图片描述

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.20.jar:8.0.20]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197) ~[mysql-connector-java-8.0.20.jar:8.0.20]
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) [HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) [HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-3.4.5.jar:na]
	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-3.4.5.jar:na]
	at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.buildSqlSessionFactory(MybatisSqlSessionFactoryBean.java:599) [mybatis-plus-extension-3.0.5.jar:na]
	at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.afterPropertiesSet(MybatisSqlSessionFactoryBean.java:386) [mybatis-plus-extension-3.0.5.jar:na]
	at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.getObject(MybatisSqlSessionFactoryBean.java:683) [mybatis-plus-extension-3.0.5.jar:na]
	at com.baomidou.mybatisplus.autoconfigure.MybatisPlusAutoConfiguration.sqlSessionFactory(MybatisPlusAutoConfiguration.java:165) [mybatis-plus-boot-starter-3.0.5.jar:na]
	at com.baomidou.mybatisplus.autoconfigure.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$dca35930.CGLIB$sqlSessionFactory$0(<generated>) [mybatis-plus-boot-starter-3.0.5.jar:na]
	at com.baomidou.mybatisplus.autoconfigure.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$dca35930$$FastClassBySpringCGLIB$$ac63376.invoke(<generated>) [mybatis-plus-boot-starter-3.0.5.jar:na]
	at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) [spring-core-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) [spring-context-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at com.baomidou.mybatisplus.autoconfigure.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$dca35930.sqlSessionFactory(<generated>) [mybatis-plus-boot-starter-3.0.5.jar:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_241]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_241]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_241]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_241]
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:650) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:635) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1338) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1177) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:557) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1304) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1224) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1511) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1406) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1304) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1224) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:130) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1422) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1304) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1224) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:130) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1422) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:226) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:893) ~[spring-beans-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879) ~[spring-context-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.7.RELEASE.jar:5.2.7.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.3.1.RELEASE.jar:2.3.1.RELEASE]
是一只不会游泳的鱼
关注
专栏目录
SpringBoot中配置数据源后出现(using password: YES)错误
pannubi的博客
08-07 1073
异常问题 java.sql.SQLException: Access denied for user ‘’@‘xxx.xxx.xxx.1’ (using password: YES) 解决方案，应该注意yml属性中的键名不能出现jdbc-url、driver-class-name 原因，查看DataSourceProperties的成员属性可以知道，部分源码中的属性部分，如下显示 /** * Fully qualified name of the JDBC driver. * Auto
IDEA运行SSM项目报错，java.sql.SQLException: Access denied for user root localhost (using password YES)
LagerSwan的博客
05-19 3779
今天导入一个 Eclipse 的SSM项目到 IDEA 中进行测试，在进行数据库操作时出现了SQLException异常： java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) 异常代码大致如下：（因为异常提示太多了，这里就不全部显示了）； java.sql.SQLException: Access denied for user 'root'@'localhost' (usin
SpringBoot项目 java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
凌咚的博客
03-10 1255
​ 虽然SpringBoot帮我们做了许多工作，但是不明白内部原理极其容易出错，作为初学者应该稳扎稳打，理解底层原理。作为一位SpringBoot的初学者，学时尚浅，如有错误欢迎指出。​ 成功解决问题，这个问题比较特殊，一般数据库密码不可能纯数字，因此企业开发中基本不会遇到。​ 为了防止密码或者用户名解析为数值类型，将解决措施将。并且数据库密码是全数字，并且以。会被解析成八进制数值，就是十进制的。，解析为字符串类型，防止错误解析。文件的读取方式导致的密码错误，来读取不同进制的数值类型，例如。
spring boot 项目启动报错：SQLException： Access denied for user 'root'@'localhost' (using password:YES）
weixin_46075653的博客
04-10 2951
spring boot 项目启动报错：java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES) 今天在学习过程中，遇到这么一个问题，之前没碰到过，在此记录一下。 spring boot 项目启动中报错：java.sql.SQLException: Access denied for ...
Springboot连接mysql时报错Access denied for user 'root'@'localhost' (using password: YES)
leiming01的博客
08-06 4579
解决办法：application.yml配置文件中的密码用单引号引起来
Springboot： java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
MQZJ12345的专栏
08-22 243
Springboot： java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) yml配置： server: port: 9011 spring: application: name: goods datasource: driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://192.168
springBoot Bug记录:java.sql.SQLException: Access denied for user 'root'@'localhost'
晚风的博客
04-14 1558
文章目录今天在写springBoot连接数据库的时候遇到一个bug,故写此贴记录一下解决方法开发环境：问题描述:使用 application.properties配置连接数据库正常连接,而使用application.yml连接数据库报错:报错内容:java.sql.SQLException: Access denied for user 'root'@'localhost' (using pass...
记录因为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: ...
【解决报错】java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
热门推荐
qiiingc的解题记录
03-05 2万+
IDE：IntelliJ IDEA Ultimate 2019.3 （我用的是学生版，只要大学邮箱能用就可以的） 报错信息全文附在最后。其中关键的信息就是： Root Cause java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) 解决方法 1.首先，如果项目是你...
IDEA连接mysql报错 java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
weixin_44772109的博客
01-23 4730
IDEA连接mysql报错 java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES) at com.mysql 和报错： Sat Jan 23 10:18:29 CST 2021 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to My
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'在本地主机上使用了错误的密码进行连接。 解决这个问题的方法有以下几种： ...
启动springboot项目Access denied for user ‘root‘@‘localhost‘ (using password: YES)
wenqi
01-03 1317
只想吐槽一句，yml文件坑好多 昨天在启动springboot项目时候，一直遇到启动java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)的问题，排查了好久， 但是自己的配置文件看了好久没找到问题，今天早上找了一篇帖子，解决了，配置data-source-password ：“root”，这里密码要加上""。 附上原帖：https://blog.csdn.net/zhang_cl_cn/.
SpringBoot(5)报错Access denied for user ‘root‘@‘localhost‘ (using password: YES)
wgx_0504的博客
10-28 1777
SpringBoot报错Access denied for user ‘root‘@‘localhost‘ (using password: YES)
SpringBoot项目连接数据库报错：Access denied for user 'root'@'localhost' (using password: YES)
最初的模样
12-09 874
原文链接：https://blog.csdn.net/u012862619/article/details/80482485，博主已经写的很详细，我就直接拿过来了，小问题需谨慎。 SpringBoot项目配置文件有两种格式，常用的application-xx.properties和最新的application-xx.yml。 运行项目时常常出现以上错误。一般是两个原因导致的：要么是连接信息配置错...
Springboot项目连接到Mysql数据库报错：Access denied for user 'root'@'localhost' (using password: YES)
blog
01-08 5990
Springboot项目连接报错：java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES) 按照别人的步骤构建了一个Springboot项目之后，也按照别人的application.yml文件把spring数据源文件配置了一下，然后别人的配置文件是这样的： 于是我也按照配置格式把...
SpringBoot连接数据库报错：Access denied for user 'root'@'localhost' (using password: YES)
仙女的博客
03-26 5328
springboot项目连接数据库的时候报错，大概意思是被拒绝访问了 妈耶要吐血了，找了一上午，修改了有的说用户名用root可能会报错我把用户名改了，有的说权限不够，我改了访问mysql的权限都没什么用，最后看了一个大佬的博客才知道是因为配置文件格式的问题，如果用properties配置是没有问题的，但是用yml就会报错。 这是我之前的application.yml中数据库的配置，看...
Springboot中的Java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
m0_59486738的博客
07-29 505
遇到这个问题时查资料说是用到了密码但是密码错误，但是反复检查后发现数据库用户名（root）和密码确实没有错误，后来把root对应的密码改了，将新密码写入application.yml文件就好了，具体原因我也不清楚。...
SpringBoot连接mysql密码正确但SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
weixin_53273474的博客
09-19 652
SpringBoot连接mysql密码正确但SQLException: Access denied for user 'root'@'localhost' (using password: YES)
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值