This module provides the capability to manage your mysql installation, users, permissions and databases.

This module has evolved and is originally based on work by David Schmitt. 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

mysql

Installs the mysql-client package

class { 'mysql': }

mysql::python

Installs mysql bindings for python:

class { 'mysql::python': }

mysql::ruby

Installs mysql bindings for ruby:

class { 'mysql::ruby': }

mysql::server

Installs mysql-server, starts service, sets root_pw, and sets root login information in /etc/.my.cnf and /root/.my.cnf.

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

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'] ,
}

Bugs

Bugs can be reported in the Puppetlabs Redmine project:

http://projects.puppetlabs.com/projects/modules/

Just ensure you raise the bug with the category mysql.