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