gistfile1.txt

db_password = "somepassword"
mysql_command = "mysql -u root -p#{node[:mysql][:server_root_password]} -e"

bash "setup_#{app}_db" do
  code <<-EOH
    #{mysql_command} "CREATE DATABASE #{app}"
    #{mysql_command} "GRANT ALL PRIVILEGES ON #{app}.* \
      TO '#{site}'@'localhost' \
      IDENTIFIED BY '#{db_password}' \
      WITH GRANT OPTION"
    date > /var/lib/mysql/setup_#{app}_db
    echo 'chef created #{app} database' >> /var/lib/mysql/setup_#{app}_db
  EOH
  not_if {File.exists?("/var/lib/mysql/setup_#{app}_db")}
end