java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)解决方法

最新推荐文章于 2024-07-31 10:29:06 发布
最新推荐文章于 2024-07-31 10:29:06 发布
阅读量3.8k 收藏
点赞数 1
分类专栏： MySQL
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/nvxiaq/article/details/77089316
版权
刚安装的mysql，在项目运行时出现 
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)


信息如下：

09:58:53,666 |-WARN in ch.qos.logback.core.db.DriverManagerConnectionSource@298f8601 - Could not discover the dialect to use. java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
	at 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
	at 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
	at 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
	at 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
	at 	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1659)
	at 	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1206)
	at 	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2239)
	at 	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2270)
	at 	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2069)
	at 	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
	at 	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
	at 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at 	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
	at 	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
	at 	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
	at 	at java.sql.DriverManager.getConnection(Unknown Source)
	at 	at java.sql.DriverManager.getConnection(Unknown Source)
	at 	at ch.qos.logback.core.db.DriverManagerConnectionSource.getConnection(DriverManagerConnectionSource.java:54)
	at 	at ch.qos.logback.core.db.ConnectionSourceBase.discoverConnectionProperties(ConnectionSourceBase.java:48)
	at 	at ch.qos.logback.core.db.DriverManagerConnectionSource.start(DriverManagerConnectionSource.java:38)
	at 	at ch.qos.logback.core.joran.action.NestedComplexPropertyIA.end(NestedComplexPropertyIA.java:167)
	at 	at ch.qos.logback.core.joran.spi.Interpreter.callEndAction(Interpreter.java:317)
	at 	at ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:196)
	at 	at ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:182)
	at 	at ch.qos.logback.core.joran.spi.EventPlayer.play(EventPlayer.java:62)
	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:149)
	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:135)
	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:99)
	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:49)
	at 	at ch.qos.logback.classic.util.ContextInitializer.configureByResource(ContextInitializer.java:75)
	at 	at ch.qos.logback.classic.util.ContextInitializer.autoConfig(ContextInitializer.java:150)
	at 	at org.slf4j.impl.StaticLoggerBinder.init(StaticLoggerBinder.java:85)
	at 	at org.slf4j.impl.StaticLoggerBinder.<clinit>(StaticLoggerBinder.java:55)
	at 	at ch.qos.logback.ext.spring.LogbackConfigurer.initLogging(Unknown Source)
	at 	at ch.qos.logback.ext.spring.web.WebLogbackConfigurer.initLogging(Unknown Source)
	at 	at ch.qos.logback.ext.spring.web.LogbackConfigListener.contextInitialized(Unknown Source)
	at 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4772)
	at 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5196)
	at 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1409)
	at 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1399)
	at 	at java.util.concurrent.FutureTask.run(Unknown Source)
	at 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at 	at java.lang.Thread.run(Unknown Source)
09:58:53,671 |-ERROR in ch.qos.logback.core.joran.spi.Interpreter@25:15 - RuntimeException in Action for tag [appender] java.lang.IllegalStateException: DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect
	at java.lang.IllegalStateException: DBAppender cannot function if the JDBC driver does not support getGeneratedKeys method *and* without a specific SQL dialect
	at 	at ch.qos.logback.core.db.DBAppenderBase.start(DBAppenderBase.java:62)
	at 	at ch.qos.logback.classic.db.DBAppender.start(DBAppender.java:93)
	at 	at ch.qos.logback.core.joran.action.AppenderAction.end(AppenderAction.java:96)
	at 	at ch.qos.logback.core.joran.spi.Interpreter.callEndAction(Interpreter.java:317)
	at 	at ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:196)
	at 	at ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:182)
	at 	at ch.qos.logback.core.joran.spi.EventPlayer.play(EventPlayer.java:62)
	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:149)
	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:135)
	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:99)
	at 	at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:49)
	at 	at ch.qos.logback.classic.util.ContextInitializer.configureByResource(ContextInitializer.java:75)
	at 	at ch.qos.logback.classic.util.ContextInitializer.autoConfig(ContextInitializer.java:150)
	at 	at org.slf4j.impl.StaticLoggerBinder.init(StaticLoggerBinder.java:85)
	at 	at org.slf4j.impl.StaticLoggerBinder.<clinit>(StaticLoggerBinder.java:55)
	at 	at ch.qos.logback.ext.spring.LogbackConfigurer.initLogging(Unknown Source)
	at 	at ch.qos.logback.ext.spring.web.WebLogbackConfigurer.initLogging(Unknown Source)
	at 	at ch.qos.logback.ext.spring.web.LogbackConfigListener.contextInitialized(Unknown Source)
	at 	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4772)
	at 	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5196)
	at 	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1409)
	at 	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1399)
	at 	at java.util.concurrent.FutureTask.run(Unknown Source)
	at 	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at 	at java.lan八月 11, 2017 9:58:53 上午 org.apache.catalina.core.ApplicationContext log
信息: JUL to SLF4J bridge is not available on the classpath
g.Thread.run(Unknown Source)


然后打开sql文件中的mysql.exe也是闪退，在小黑框中打开mysql，也报错误： “Access denied for user 'ODBC'@'localhost' (using password:NO)”

网上搜了一下解决方案：

在Mysql目录下my.ini文件中，最后一行添加“skip-grant-tables”，保存并关闭文件。

重启mysql服务，再执行。

问题解决！


不想再做猿了
关注
专栏目录
【解决报错】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运行SSM项目报错，java.sql.SQLException: Access denied for user root localhost (using password YES)
LagerSwan的博客
05-19 3754
今天导入一个 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
java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
S852509769的博客
10-24 1万+
解决程序中数据库连接配置问题
Access denied for user ‘root‘@‘localhost‘ (using password:YES)解决方法
最新发布
lza20001103的博客
07-31 8491
Access denied for user 'root'@'localhost' (using password:YES)解决方法
Caused by: java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
m0_65041486的博客
08-05 5426
连接数据库的一个离谱bug========================================================================
已解决java.sql.SQLException: Access denied for user ‘root ‘@‘localhost‘ (using password: YES)
热门推荐
03-29 7万+
对于 “java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)” 这个错误，通常是因为数据库连接的用户名或密码不正确，导致无法访问数据库。
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.
qq_44837994的博客
02-19 484
java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) 错误原因： 1，驱动配置有误：driver=com.mysql.jdbc.Driver 2，数据...
IDEA连接mysql报错 java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
weixin_44772109的博客
01-23 4708
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: ...这些方法应该能够帮助你解决java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)错误。
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
牛哞哞杂记
03-13 1万+
错误：java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES) 原因：连接的用户名和密码错误（多打了空格） 网上找了有三种原因： 1、用户名和密码不匹配，或者是在连接池里多打了空格之类的 2、可能是用户的权限不够，给他添加权限 3、编码的问题 我很奇怪，明明一样的项目，一个报错一个没...
【已解决】java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
CSDNliuty的博客
05-07 7453
这听起来不太可能，因为 root 用户通常默认就有这样的权限，但如果你之前修改了权限，那就可能发生了这种情况。如果你在云服务器上运行 MySQL，检查安全组或防火墙规则，确保它们允许从你的应用程序所在的主机到 MySQL 服务器的连接。请检查你的密码是否正确，并确保你没有在密码中不小心包含了额外的空格或字符。：my.cnf 或 my.ini（取决于你的操作系统和安装方式）中的某些设置可能阻止了 root 用户的登录。：如果你使用的是云服务或防火墙，可能存在阻止连接的安全组规则或防火墙规则。
Linux学习——Mysql报错：Error: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
学渣Tina的博客
05-16 5769
Mysql报错：Error: Access denied for user 'root'@'localhost' (using password: YES)
JSP连接MySQL时出现--错误：Access denied for user 'root'@'localhost' (using password: YES)&#3...
weixin_33767813的博客
12-25 178
用代码进行用户验证的时候总是出现这个错误，翻译一下，应该是root用户的是权限的问题没有放开。 那就想办法解决一下吧，具体的来说可以有这样的几种方式。 解决方法，首先想到的是先重启一下MySQL服务吧，但是试了一下，发现这并没有什么用。 网上搜索了一下，相关于MySQL的权限的释放和管理问题，找到一个比较好的答案： //首先...
解决java.sql.SQLException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
Jonny_Wang的博客
04-15 7万+
mysql 5.7.17 数据库拒绝访问
Caused by: java.sql.SQLException: Access denied for user ‘root ‘@‘localhost‘ (using password: YES)
ly1316221439的博客
02-08 2002
数据库连接错误
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值