Template from library method

gistfile1.rb

def give_user_root_access(user, root_password)
  Chef::Log.info "Giving #{user} root access to MySQL server"
  home_dir = case user
  when 'root'
    '/root'
  else
    "/home/#{user}"
  end

  Chef::Resource::Template.new "#{home_dir}/.my.cnf" do
    source "user_my_cnf.erb"
    owner user
    group user
    mode "0600"
    variables :user => "root", :password => root_password
  end
end