def sql = Sql.newInstance('jdbc:mysql://host:port/dbname',
         'user', 'pass', 'com.mysql.jdbc.Driver')
def result = sql.eachRow('SELECT * from MYTABLE'){ row ->
    println row[0]
 }
sql.close()