Module mysql
In: /etc/puppet/modules/mysql/lib/puppet/parser/functions/mysql_password.rb
/etc/puppet/modules/mysql/lib/puppet/provider/database/mysql.rb
/etc/puppet/modules/mysql/lib/puppet/provider/database_grant/mysql.rb
/etc/puppet/modules/mysql/lib/puppet/provider/database_user/mysql.rb
/etc/puppet/modules/mysql/lib/puppet/type/database.rb
/etc/puppet/modules/mysql/lib/puppet/type/database_user.rb
/etc/puppet/modules/mysql/lib/puppet/type/database_grant.rb
/etc/puppet/modules/mysql/manifests/config.pp
/etc/puppet/modules/mysql/manifests/server.pp
/etc/puppet/modules/mysql/manifests/python.pp
/etc/puppet/modules/mysql/manifests/php.pp
/etc/puppet/modules/mysql/manifests/db.pp
/etc/puppet/modules/mysql/manifests/params.pp
/etc/puppet/modules/mysql/manifests/backup.pp
/etc/puppet/modules/mysql/manifests/init.pp
/etc/puppet/modules/mysql/manifests/server/mysqltuner.pp
/etc/puppet/modules/mysql/manifests/server/config.pp
/etc/puppet/modules/mysql/manifests/server/account_security.pp
/etc/puppet/modules/mysql/manifests/server/monitor.pp
/etc/puppet/modules/mysql/manifests/java.pp
/etc/puppet/modules/mysql/manifests/ruby.pp

Defines

db  

Plugins

database   database_user   database_grant  

Classes and Modules

Class mysql::backup
Class mysql::config
Class mysql::java
Class mysql::mysql
Class mysql::params
Class mysql::php
Class mysql::python
Class mysql::ruby
Class mysql::server

Defines

db( $sql => '', $grant => 'all', $charset => 'utf8', $ensure => 'present', $enforce_sql => 'false', $host => 'localhost', $password, $user )

Define: mysql::db

This module creates database instances, a user, and grants that user privileges to the database. It can also import SQL from a file in order to, for example, initialize a database schema.

Since it requires class mysql::server, we assume to run all commands as the root mysql user against the local mysql server.

Parameters:

  [*title*]       - mysql database name.
  [*user*]        - username to create and grant access.
  [*password*]    - user's password.
  [*charset*]     - database charset.
  [*host*]        - host for assigning privileges to user.
  [*grant*]       - array of privileges to grant user.
  [*enforce_sql*] - whether to enforce or conditionally run sql on creation.
  [*sql*]         - sql statement to run.
  [*ensure*]      - specifies if a database is present or absent.

Actions:

Requires:

  class mysql::server

Sample Usage:

 mysql::db { 'mydb':
   user     => 'my_user',
   password => 'password',
   host     => $::hostname,
   grant    => ['all']
 }

[Validate]