Skip to content

Instantly share code, notes, and snippets.

@deinspanjer
Created January 22, 2014 22:03
Show Gist options
  • Save deinspanjer/8568307 to your computer and use it in GitHub Desktop.
Save deinspanjer/8568307 to your computer and use it in GitHub Desktop.
class { '::mysql::server':
override_options => { 'mysqld' => {
'query_cache_limit' => '128M',
'query_cache_size' => '256M',
'query_cache_type' => '1',
}, 'mysqld_safe' => {
# Set the MySQL timezone.
# @see http://stackoverflow.com/questions/947299/how-do-i-make-mysqls-now-and-curdate-functions-use-utc
'timezone' => 'UTC',
}
},
}
class { '::mysql::bindings':
java_enable => 1,
}
mysql::db { 'steelwheels':
user => 'xxx',
password => 'xxx',
host => 'localhost',
}
mysql_grant { 'xxx@localhost/*.*':
ensure => 'present',
options => ['GRANT'],
privileges => ['ALL'],
table => '*.*',
user => 'xxx@localhost',
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment