This looks like a good opportunity for the various mysql module authors to all get together and produce one single awesome module :)
On Sun, Jul 10, 2011 at 3:49 AM, Andrew Thompson <netengr2...@gmail.com>wrote: > Take a look at example42's mysql module. I use it to change the root > password and create users for each of my applications. Look at this > specifically: > > https://github.com/example42/puppet-modules/blob/master/mysql/manifests/grant.pp > > There is also a "query" define so you can run any query that is possible > from the mysql client. > > -Andrew > On Jul 10, 2011 6:27 AM, "newguy" <aimanparv...@gmail.com> wrote: > > Hey > > I will try to write again what I wanted to say in the first message: > > Is it possible through puppet that I install mysql and define what > > would be mysql username, password for that client and also I want to > > disable root user through puppet, can this be achieved. > > > > Thanks > > > > > > On Jul 9, 10:54 pm, Gabriel Filion <lelu...@gmail.com> wrote: > >> On 11-07-10 12:48 AM, newguy wrote: > >> > >> > I have 2 types of clients(developers, users) connecting to my puppet > >> > server, puppet installs mysql on both the machines but I want that > >> > when its user machine connecting to server the mysql root user is > >> > disabled and a user account should be made with a custom password and > >> > for developers machine puppet makes a root user with an option to > >> > select a password(right now puppet just installs mysql with root user > >> > and without asking for any root password), developers should also be > >> > able to make a non root account through puppet on mysql. > >> > >> > Is this possible with puppet, please help. > >> > >> I'm not entirely sure what the long sentence is asking about, but yes I > >> guess it should be possible. > >> > >> the following module includes custom resource types that could help you > >> out (Mysql_database, Mysql_user, Mysql_grant): > >> > >> https://labs.riseup.net/code/projects/shared-mysql > >> > >> check out 'lib/puppet/type' > >> > >> -- > >> Gabriel Filion > > > > -- > > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > > To post to this group, send email to puppet-users@googlegroups.com. > > To unsubscribe from this group, send email to > puppet-users+unsubscr...@googlegroups.com. > > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to > puppet-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > -- Nigel Kersten Product Manager, Puppet Labs Twitter: @nigelkersten *Join us for **PuppetConf *<http://www.bit.ly/puppetconfsig> September 22nd and 23rd in Portland, Oregon, USA. * * -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.