Chef and Vagrant setup to easily create databases as needed

default.rb

# create all the databases from the Vagrantfile json config
node[:db].each do |env, name|
	execute "create database #{name}" do
		command "mysql -uroot -p#{node[:mysql][:server_root_password]} -e 'create database if not exists #{name}'"
		user "vagrant"
	end
end

Vagrantfile

Vagrant::Config.run do |config|

  config.vm.box = "lucid32"
  config.vm.box_url = "http://files.vagrantup.com/lucid32.box"

  config.vm.provision :chef_solo do |chef|
    chef.cookbooks_path = "cookbooks"
    
    # pass json_attribs to chef
    chef.json = {
      "development" => true,
      "mysql" => {
        "server_root_password" => "<PW>",
        "allow_remote_root" => true,
        "bind_address" => "0.0.0.0",
      },
      "db" => {
        "prod" => "db_prod",
        "test" => "db_test",
        "dev" => "db_dev"
      }
    }
  end

Just what I needed! cheers!