It maybe help someone else: mysql user and mysql grant

[pier4r]

I found the example of the mysql module a bit limited, I mean this

Therefore after some trial and error I found a more poingant example (with networks). Maybe it can help someone else if it is posted.

mysql_user {
    default:
        ensure  => present,
        require => Class['mysql::server'],
    ;
    '[email protected]/255.255.255.0':
        password_hash => mysql::password('cleartextpassword here'),
    ;
    '[email protected]/255.255.255.0':
        password_hash => mysql::password('cleartextpassword here'),
    ;
}

mysql_grant {
    default:
        ensure     => 'present',
        privileges => ['ALL'], #grant all privileges on a db.
        require    => Class['mysql::server'],
    ;
    '[email protected]/255.255.255.0/testdb.*': #the format is $user/$table
        user  => '[email protected]/255.255.255.0',
        table => 'testdb.*', # the entire db tables
    ;
    '[email protected]/255.255.255.0/anotherdb.*':
        user  => '[email protected]/255.255.255.0',
        table => 'anotherdb.*',
    ;
}

[b4ldr]

perhaps create a PR to https://github.com/puppetlabs/puppetlabs-mysql