Re: [Puppet Users] Puppet MySQL Module

2013-03-05 Thread Arnau Bria
On Tue, 5 Mar 2013 10:48:16 +0200 Nikola Petrov wrote: > You can use the database_grant resource type. Here is an example: But how may I set its password? (it's working cause my user was correctly created and I set its passwd before). *Sorry, I did reply too early.. Cheers, Arnau -- You

Re: [Puppet Users] Puppet MySQL Module

2013-03-05 Thread Arnau Bria
On Tue, 5 Mar 2013 10:48:16 +0200 Nikola Petrov wrote: Hi Nikola, > You can use the database_grant resource type. Here is an example: > > database_grant { "${user}@${::hostname}/${db}": > privileges => ['select'], # anything you want > require=> Database_user["${user}@${::hostname}

Re: [Puppet Users] Puppet MySQL Module

2013-03-05 Thread Nikola Petrov
You can use the database_grant resource type. Here is an example: database_grant { "${user}@${::hostname}/${db}": privileges => ['select'], # anything you want require=> Database_user["${user}@${::hostname}"], } set the $user and $db variables to what you want ;) More information

[Puppet Users] Puppet MySQL Module

2013-03-05 Thread Arnau Bria
Hi all, I'm using the MySQL module https://forge.puppetlabs.com/puppetlabs/mysql and I can't find the way to give certain permission to a secondary user over an already created DB (which has it own user): mysql::db { 'galaxy': user => 'galaxy', passwor