CODEWITHSUNDEEP
javamysqlspring-boot
Anton Styopin
Anton Styopin

Reputation: 753

Why doesn't spring-boot connect to local mysql server?

Cant get springboot connected to my localhost mysql database.

This is my project structure:

enter image description here

This is the error-log.

enter image description here

It is strange that he says: "Access denied for user ''@'localhost' (using password: NO)", but in my application.properties i have written connection:

server.port=8080
spring.main.banner-mode=off
spring.thymeleaf.cache=false
spring.freemarker.cache=false
spring.groovy.template.cache=false
spring.datasource.url=jdbc:mysql://localhost:3306/user?autoReconnect=true&useSSL=false
spring.datasource.data-username=root
spring.datasource.data-password=stepin
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true

My build.gradle file:

buildscript {
ext {
    springBootVersion = '1.4.1.RELEASE'
}
repositories {
    mavenCentral()
}
dependencies {
    classpath("org.springframework.boot:spring-boot-gradle-    plugin:${springBootVersion}")
}
}

apply plugin: 'java'
apply plugin: 'eclipse'
apply plugin: 'spring-boot'

jar {
    baseName = 'databaseaccess'
    version = '0.0.1-SNAPSHOT'
}
sourceCompatibility = 1.8
targetCompatibility = 1.8

repositories {
    mavenCentral()
}


dependencies {
    compile('org.springframework.boot:spring-boot-starter-data-jpa')
    compile('org.springframework.boot:spring-boot-starter-web')
    compile('mysql:mysql-connector-java')
    runtime("com.h2database:h2")
    testCompile('org.springframework.boot:spring-boot-starter-test')
}

I am new with springboot, but i can connect to my local database, when i write normal java connection, so why springboot cant?

Upvotes: 5

Views: 5415

Answers (1)

Slava Semushin
Slava Semushin

Reputation: 15214

I suspect this is because of these properties:

spring.datasource.data-username=root
spring.datasource.data-password=stepin

Try to replace them by

spring.datasource.username=root
spring.datasource.password=stepin

It's possible to have 2 different users for executing DDL and DML operations. You specified the second and didn't provide the first.

Quote from https://github.com/spring-projects/spring-boot/blob/master/spring-boot-docs/src/main/asciidoc/appendix-application-properties.adoc:

spring.datasource.data= # Data (DML) script resource reference.
spring.datasource.data-username= # User of the database to execute DML scripts (if different).
spring.datasource.data-password= # Password of the database to execute DML scripts (if different).
spring.datasource.username=
spring.datasource.password= # Login password of the database.

Upvotes: 5

Related Questions