mysql: flush privileges, autorequire, minor adjustments

This commit executes a mysqladmin flush-privileges after every modification
 of users or grants, thereby enabling mysql to actually look at the changes too.

grants now autorequire the appropriate db and user

adjustet my site.pp for new types

1 files changed, 7 insertions, 0 deletions

diff --git a/plugins/puppet/provider/mysql_grant/mysql.rb b/plugins/puppet/provider/mysql_grant/mysql.rb
index 9d900ec..93d7ecf 100644
--- a/plugins/puppet/provider/mysql_grant/mysql.rb
+++ b/plugins/puppet/provider/mysql_grant/mysql.rb
@@ -10,6 +10,11 @@ Puppet::Type.type(:mysql_grant).provide(:mysql) do
 	desc "Uses mysql as database."
 
 	commands :mysql => '/usr/bin/mysql'
+	commands :mysqladmin => '/usr/bin/mysqladmin'
+
+	def mysql_flush 
+		mysqladmin "flush-privileges"
+	end
 
 	# this parses the
 	def split_name(string)
@@ -44,6 +49,7 @@ Puppet::Type.type(:mysql_grant).provide(:mysql) do
 					name[:host], name[:user], name[:db],
 				]
 			end
+			mysql_flush
 		end
 	end
 
@@ -129,6 +135,7 @@ Puppet::Type.type(:mysql_grant).provide(:mysql) do
 		stmt = stmt << set << where
 
 		mysql "mysql", "-Be", stmt
+		mysql_flush
 	end
 end