亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全，請及時綁定郵箱和手機立即綁定

mysql賬號密碼是正確的，但是一直報賬號密碼錯誤。

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
<dependency>
???<groupId>org.springframework.boot</groupId>
???<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<dependency>
???<groupId>mysql</groupId>
???<artifactId>mysql-connector-java</artifactId>
</dependency>

報錯信息：

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.<init>(ConnectionImpl.java:779)?~[mysql-connector-java-5.1.42.jar:5.1.42]
????at?com.mysql.jdbc.JDBC4Connection.<init>(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.<init>(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]



正在回答

6 回答

如果密碼是0開頭的話，會自動吧0去掉所以會失敗。

解決：1、改密碼

????????????2、加單引號：'password'

1 回復 有任何疑惑可以回復我~
#1

Knight_ 提問者

是這個問題，我新創的用戶密碼不是0開頭就能成功連接了
2018-03-28 回復 有任何疑惑可以回復我~

http://img1.sycdn.imooc.com//5a0e682000019cc307060429.jpg

http://img1.sycdn.imooc.com//5a0e68200001368407060429.jpg

我重新創了個用戶，給了全局特權有用了，其他遇到這個問題的小伙伴可以試一下

0 回復 有任何疑惑可以回復我~

我和你一樣的錯誤，調試了一天沒找出原因，重新安裝了一遍數據庫，重新創建了項目可以了，我也是醉了。但是我猜測是數據庫密碼和Windows關鍵字重復產生的影響，我自己的猜測

0 回復 有任何疑惑可以回復我~
#1

Knight_ 提問者

老鐵，我重裝了還是沒有用，你重裝更改了什么嘛？
2017-11-17 回復 有任何疑惑可以回復我~

我調試了一天還是沒有解決，現在重裝一次mysql試試，要是能解決稍后跟大家分享

0 回復 有任何疑惑可以回復我~

不對啊，也沒說你賬戶名密碼不匹配啊，就是權限拒絕。。。還好我看了一眼

0 回復 有任何疑惑可以回復我~
#1

qq_堅強的小石頭_03741028

這樣該怎樣解決？我連接本地的數據庫需要權限嗎
2017-11-16 回復 有任何疑惑可以回復我~
#2

Knight_ 提問者

雖然說默認root沒有遠程連接權限，可是自帶了本地連接權限啊
2017-11-17 回復 有任何疑惑可以回復我~

別想了，就是賬戶名密碼不匹配

0 回復 有任何疑惑可以回復我~

舉報

0/150
提交
取消
2小時學會Spring Boot
  • 參與學習       151526    人
  • 解答問題       1132    個

Spring Boot入門視頻教程，你將學會使用Spring Boot快速構建應用程序

進入課程

mysql賬號密碼是正確的，但是一直報賬號密碼錯誤。

我要回答 關注問題
微信客服

購課補貼
聯系客服咨詢優惠詳情

 幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

 公眾號

掃描二維碼
關注慕課網微信公眾號