Puppet users - Dec 2013 - MySql: allow user root to access from any host

Hey,
I''m doing my first steps with puppet right now and I''m trying
to set up a
dev machine.
For this I''m installing MySql and want to do some initial set up.
The server is up and running and also my database is created.
Now I want to allow the user root to login from any host because I want to 
connect with a tool to my database.

I''ve tried this:

mysql_grant {  ''root@%/*.*'':
table      => ''*.*'',
privileges => [''ALL''], 
user => ''root@%''
}

and modified in I dozen ways bit it will just not work.
I hope you can help me.

How do I grant the user root access from any host!?

Felix

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to puppet-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/ee63ee8a-e44e-4f23-863c-e2e7a4a544bb%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

On Sat, Dec 14, 2013 at 7:04 AM, Felix Gläske <skellon@gmail.com>
wrote:
> Hey,
> I''m doing my first steps with puppet right now and I''m
trying to set up a
> dev machine.
> For this I''m installing MySql and want to do some initial set up.
> The server is up and running and also my database is created.
> Now I want to allow the user root to login from any host because I want to
> connect with a tool to my database.
>
> I''ve tried this:
>
> mysql_grant {  ''root@%/*.*'':
> table      => ''*.*'',
> privileges => [''ALL''],
> user => ''root@%''
> }
>
> and modified in I dozen ways bit it will just not work.
> I hope you can help me.
>
> How do I grant the user root access from any host!?
Sorry for the lame reply of RTFM - it''s what I''ve done in the
past.

Both the MySQL and PostgreSQL puppet modules are pretty readable and
you can divine how their puppet resource parameters map to SQL
statements.

HTH,

-mz

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to puppet-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/CAOLfK3Vci4FwyryoHOpFAMQXRmfuGMhNtvMM2v4-HcDZT%2Bj2zA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.