user-cookbook-mysql-perms.rb

if u.has_key?("mysql_permissions") and u[:mysql_permissions].has_key?(node.name) then
  u[:mysql_permissions]["#{node.name}"].each do |database, grants| 
    Chef::Log.info("Found permission on #{node.name} for #{u[:id]}: DB: #{database}, Grants: #{grants.join(',')}")
    execute "grant-#{u[:id]}-#{database}-perms" do
      command "/usr/bin/mysql -u root -p#{mysql_password} -D mysql -r -B -N -e \"GRANT #{grants.join(',')} ON #{database}.* to '#{u[:id]}'@'localhost'\""
      action :run
      not_if { `/usr/bin/mysql -u root -p#{mysql_password} -D mysql -r -B -N -e \"SELECT COUNT(*) FROM user where User='#{u[:id]}' and Host = 'localhost'"`.to_i == 0 }
    end
  end 
end