How do I enable h2 console in application.yml for SpringBoot?

Question

I have an application.yml file where I want to enable h2-console but on searching over google I got results only for application.properties file. Can anyone help?

Answer 1

You can use below configuration.

spring:
  h2:
    console:
      enabled: true
      path: /h2-console

Refer this for more : https://github.com/khoubyari/spring-boot-rest-example/blob/master/src/main/resources/application.yml

AND

https://docs.spring.io/spring-boot/docs/current-SNAPSHOT/reference/htmlsingle/#boot-features-sql-h2-console

Answer 2

you need to use this structure

###
#   H2 Settings
###
  h2:
    console:
      enabled: true
      path: /console
      settings:
        trace: false
        web-allow-others: false