Read database.yml file and generate sql to create databases

rails_db_create.rb

#!/usr/bin/env ruby

# Read database.yml file and generate sql to create databases
# ./rails_db_create.rb | mysql

require 'yaml'

config = YAML.load_file 'database.yml'

dbs = {}

config.each do |env, opts|
  dbs[opts['database']] = opts
end
                                     
dbs.each do |db, opts|               
  puts "CREATE DATABASE `#{db}` DEFAULT CHARACTER SET #{opts['encoding']};"
  puts "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX
      ON #{db}.*                     
          TO #{opts['username']}@localhost IDENTIFIED BY '#{opts['password']}';
      flush privileges;"             
end