Properties - PalmaDev/GrailsAppBase GitHub Wiki

Create a new folder in $HOME with name ".folderProperties"

Inside must create a new file with name "fileProperties-development.groovy"

And then, open this file and put the config for database:

dataSource {
  pooled = true
  dbCreate = "none"
  driverClassName = "com.mysql.jdbc.Driver"
  username = "username"  //change for your username
  password = "password" //change for your password
  url = "jdbc:mysql://localhost/bd_base_grails_app" //change name database with it yours
  properties {
    jmxEnabled = true
    initialSize = 5 
    maxActive = 50
    minIdle = 5 
    maxIdle = 25
    maxWait = 10000
    maxAge = 10 * 60000
    timeBetweenEvictionRunsMillis = 5000
    minEvictableIdleTimeMillis = 60000
    validationQuery = "SELECT 1"
    validationQueryTimeout = 3 
    validationInterval = 15000
    testOnBorrow = true
    testWhileIdle = true
    testOnReturn = false
    jdbcInterceptors = "ConnectionState"
    defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
  }
}

Next, create the database in your local server mysql with same name.