Add support to run grants on a remote mysql host

[lieutdan13]

I've come across the issue where I'm using Amazon RDS as a mysql host. RDS doesn't provide a shell, so puppet cannot be installed on it. How would you go about adding this feature?

• The host running the mysql command would need to know the credentials for a user on the remote host that has grant privileges
• Running the grant would not need to require mysql (server) to be installed on the host running the command, just the mysql client package(s)
• The file name of the grant may need to be more specific and include the grant/remote host.

[alvagante]

I think we can add 3 more options to manage remote_host, user and password. By default the grant replies on .my.cnf so these extra params would keep this default behaviour but, if defined, they can be used to remote user creation. Given the not so smart current parama names, I would use for these ones something like: remote_host, remote_user, remote_password (but if you've better names they're welcomed) .

It should not be a too difficult to make...