MySQL用一段时间密码错误_mysql账号密码是正确的，但是一直报账号密码错误。...

最新推荐文章于 2022-03-01 19:22:47 发布
最新推荐文章于 2022-03-01 19:22:47 发布
阅读量237 收藏
点赞数
文章标签： MySQL用一段时间密码错误
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39992788/article/details/113132084
版权

spring:

server:

port: 8080

datasource:

driver-class-name: com.mysql.jdbc.Driver

url: jdbc:mysql://127.0.0.1:3306/dbgirl

username: root

password: 0616

jpa:

hibernate:

ddl-auto: create

show-sql: true

org.springframework.boot

spring-boot-starter-data-jpa

mysql

mysql-connector-java

报错信息：java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2194) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2225) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2024) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:779) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_111]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_111]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_111]

at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_111]

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.42.jar:5.1.42]

at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310) ~[tomcat-jdbc-8.5.15.jar:na]

at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203) ~[tomcat-jdbc-8.5.15.jar:na]

at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735) [tomcat-jdbc-8.5.15.jar:na]

at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667) [tomcat-jdbc-8.5.15.jar:na]

at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:482) [tomcat-jdbc-8.5.15.jar:na]

at org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.java:154) [tomcat-jdbc-8.5.15.jar:na]

at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118) [tomcat-jdbc-8.5.15.jar:na]

at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107) [tomcat-jdbc-8.5.15.jar:na]

at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131) [tomcat-jdbc-8.5.15.jar:na]

at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:254) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:228) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111) [hibernate-core-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:847) [hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]

at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:874) [hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]

at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) [spring-orm-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:353) [spring-orm-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:370) [spring-orm-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:359) [spring-orm-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) [spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) [spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) [spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) [spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) [spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) [spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) [spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) [spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1078) [spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:857) [spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) [spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]

at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) [spring-boot-1.4.7.RELEASE.jar:1.4.7.RELEASE]

at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:762) [spring-boot-1.4.7.RELEASE.jar:1.4.7.RELEASE]

at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:372) [spring-boot-1.4.7.RELEASE.jar:1.4.7.RELEASE]

at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) [spring-boot-1.4.7.RELEASE.jar:1.4.7.RELEASE]

at org.springframework.boot.SpringApplication.run(SpringApplication.java:1187) [spring-boot-1.4.7.RELEASE.jar:1.4.7.RELEASE]

at org.springframework.boot.SpringApplication.run(SpringApplication.java:1176) [spring-boot-1.4.7.RELEASE.jar:1.4.7.RELEASE]

at com.knight.girl.GirlApplication.main(GirlApplication.java:11) [classes/:na]

weixin_39992788
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
解决SpringDataJPA报错：org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null w
01-21
问题描述 用SpringBoot + Spring Data JPA操作数据库 项目启动的时候 报了一个错 SpringBoot的版本是2.2.6.RELEASE org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.cla
HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect‘ not set
Shipley_Leo的博客
05-22 8663
Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set
Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set 问题的解决方法
读万卷书，行万里路
01-05 8583
环境为：Spring Boot2 + Gradle5。 使用了 spring-boot-starter-data-jpa 依赖并配置了 MySQL 驱动与相关用户名、密码等配置。启动时抛出以下异常： Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hi...
Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect‘ not set。
万事俱备，就差一个程序员了
03-01 1万+
Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set。 2021-08-15最新的spring boot，JPA+mysql，出现这个错误： Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set。 百度了好一会，发现好多人说要在application.properties里加入以下这句： sp
Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set——【hibernate 日常错误】
ENVA_shuolei的博客
12-06 9239
EN：Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set CN：访问dialectresolutioninfo不能为空时，方言没有设置。 情况一：未在【Hibernat.cfg.xml 】中配置方言                mysql数据库正常配置如下：      
易语言MYSQL密码加密
07-18
"易语言MYSQL密码加密"是一个专门针对易语言（EasyLanguage）开发的MySQL数据库密码加密解决方案。易语言是中国的一种简单易学的编程语言，它为程序员提供了一个直观的界面来编写代码。而MySQL则是一种广泛应用的...
xampp中修改mysql默认空密码（root密码）的方法分享
09-10
本文将详细介绍如何在XAMPP中修改MySQL的root密码，以及如何配置phpMyAdmin以使用新密码。 首先，我们需要知道MySQL的用户信息，包括密码，是存储在名为`mysql`的系统数据库中的`user`表内。其中，`Password`字段...
MySQL如何优雅的备份账号相关信息
09-08
在MySQL中，优雅地备份账号相关信息是数据库管理中不可或缺的一部分，特别是在进行实例迁移或系统维护时。本篇文章将深入探讨如何高效且安全地备份MySQL的账号数据，包括用户、权限和相关设置。 首先，我们需要知道...
mysql 5.7.30安装配置方法图文教程
09-10
接下来，设置MySQL账号，主要是设置超级管理员(root)的密码，并可以添加其他用户。确保设置强密码，以保证数据库的安全性。 在"Service Configuration"环节，你可以设定MySQL服务的启动选项，如服务名、自动启动和...
基于python+Django个人密码本管理系统设计与实现.docx
最新发布
08-17
基于Python+Django的个人密码本管理系统设计与实现是一项旨在为用户提供安全、便捷的密码存储和管理解决方案的项目。该项目的开发背景源于现代生活中数字账号数量的激增，每个用户可能需要记住多个网站、应用的登录...
【Hibernate】Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set
weixin_33737134的博客
05-21 2988
今天用hibernate框架写crm项目时遇到报错：Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set 说是hibernate的dialect没有设置，但是在hibernate.cfg,xml中我已经配置了。主要内容如下： hibernate.cfg.xml： <?xml ...
Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect‘ not set
weixin_46704406的博客
01-10 2016
最近在学习Hibernate，看到网上说这个框架是旧的也有的说有的公司是要求学的，我感觉既然是一个框架就有它存在的意义，还是应该学的，于是就开始遇到错误了。上述的错误是我打算向数据库中插入数据遇到的，具体代码如下： Configuration configuration = new Configuration(); SessionFactory sessionFactory = configuration.buildSessionFactory(); Session se
解决： Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
热门推荐
愿我如星君如月 ... 夜夜流光相皎洁 ...
01-04 2万+
1. 报错： Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver 2.但是，我的pom.xml中明明已经引用了： <dependency> <groupId>mysql</groupId&...
springboot启动失败：Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
藓类少女的博客
05-20 1503
报错： org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]: Invocation of init meth...
[已解决] HibernateException：当未设置“ hibernate.dialect”时，对DialectResolutionInfo的访问不能为null
从零开始的教程世界
07-20 845
I was following Hibernate Official Documentation to create a basic hibernate application with version 4.3.5.Final. When I executed the application, I got hibernate.HibernateException: Access to Dialec...
Hibernate4.3.x Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set
weixin_30527143的博客
06-24 409
如下错误 Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set。 今天没事看看新的hibernate-core-4.3.10.Final 看来官方文档。...
[Hibernate]Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set
Science & JusticeSuNq^3NM5tFn
10-07 9341
使用Hibernate官方文档上的以下代码进行测试时报出这个异常。 org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set package org.hibernate.tutorial.util; import org.h
【Spring】Spring Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect‘ not set
九师兄
04-10 470
1.配置 server.port=8998 spring.servlet.multipart.max-file-size=2048MB spring.servlet.multipart.max-request-size=2048MB spring.datasource.jdbc-url=jdbc:mysql://localhost:3306/baas_monitor?autoReconnect=false&autoReconnectForPools=true&useUnicode=true&
写一段pyqt5动态加载的ui登陆界面登陆密码和账号验证需连接由mysql创建的数据库
06-09
下面是一个简单的PyQt5动态加载UI登陆界面的例子，其中包括MySQL数据库的账号密码验证： ```python import sys from PyQt5.QtWidgets import * from PyQt5.uic import loadUi import mysql.connector class Login...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值