On Sun, Jul 10, 2011 at 3:27 AM, newguy <[email protected]> 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.
>
Yes. The riseup mysql puppet module that Gabriel pointed at will let you do
this.
Once you've installed the module in your modulepath, you should be able to
do:
mysql_user { "username@host":
ensure => present,
password_hash => "your_password_hash",
}
and
mysql_user { "root@host":
ensure => absent,
}
>
> Thanks
>
>
> On Jul 9, 10:54 pm, Gabriel Filion <[email protected]> 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 [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.
