Mysql module:

This module has evolved and is originally based on work by David
Schmidt. If anyone else was involved in the development of this module
and wants credit, let Puppetlabs know.

The mysql module is composed of the following

Classes:

class { 'mysql': } -  installs the mysql-client package

class { 'mysql::python': } - installs mysql bindings for python

class { 'mysql::ruby': } - installs mysql bindings for ruby

mysql::server - installs mysql-server, starts service, sets root_pw, and sets root

class { 'mysql::server': 
  root_password => 'foo'
}

login infomormation in /etc/.my.cnf and /root/.my.cnf

mysql::db - creates a database with a user and assign some privileges:


mysql::db { 'mydb':
  user     => 'myuser',
  password => 'mypass',
  host     => 'localhost',
  grant    => ['all'],
}

Providers for database types:

database { 'mydb':
  charset => 'latin1',
}

database_user { 'bob@localhost':
  password_hash => mysql_password('foo')
}

database_grant { 'user@localhost/database':
  privileges => ['all'] ,
}