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.
