MySql: allow user root to access from any host

[Felix Gläske]

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

[Matt Zagrabelny]

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