Grails: DataSource.groovy for MySQL

DataSourceUsingMySQL.groovy

dataSource {
    pooled = true
       driverClassName = "com.mysql.jdbc.Driver"
       username = "root"
       password = "****"
       dialect = org.hibernate.dialect.MySQL5InnoDBDialect
       properties {
          maxActive = 50
          maxIdle = 25
          minIdle = 5
          initialSize = 5
          minEvictableIdleTimeMillis = 1800000
          timeBetweenEvictionRunsMillis = 1800000
          maxWait = 10000
          ValidationQuery = 'select 1'
       }
}

hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = false
    cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory'
}
// environment specific settings
environments {
    development {
        dataSource {
            dbCreate = "none" // one of 'create', 'create-drop', 'update', 'validate', ''
            url = "jdbc:mysql://localhost/db_dev?useOldAliasMetadataBehavior=true"
        }
    }
    test {
        dataSource {
            dbCreate = "none"
            url = "jdbc:mysql://localhost/db_test?useOldAliasMetadataBehavior=true"
        }
    }
    production {
        dataSource {
            ...
        }
    }
}

dataSource {
pooled = true
dbCreate = "update"
url = "jdbc:mysql://localhost:3306/yourDb"
driverClassName = "com.mysql.jdbc.Driver"
username = "root"
password = "xxxx"
}
hibernate {
cache.use_second_level_cache = true
cache.use_query_cache = false
cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory'
}
// environment specific settings
environments {
development {
dataSource {
pooled = true
dbCreate = "update"
url = "jdbc:mysql://localhost:3306/yourDb"
driverClassName = "com.mysql.jdbc.Driver"
username = "root"
password = "xxxx"
}
}