database.yml

# MySQL.  Versions 4.1 and 5.0 are recommended.
#
# Install the MYSQL driver
#   gem install mysql2
#
# Ensure the MySQL gem is defined in your Gemfile
#   gem 'mysql2'
#
# And be sure to use new-style password hashing:
#   http://dev.mysql.com/doc/refman/5.0/en/old-client.html

<%
socket = [
  ENV['BOXEN_MYSQL_SOCKET'],
  '/tmp/mysql.sock',
  '/tmp/mysqld.sock',
  '/var/run/mysqld/mysqld.sock',
  '/var/lib/mysql/mysql.sock',
  '/opt/local/var/run/mysql5/mysqld.sock'
].detect{ |f| f && File.exist?(f) }

port = ENV['BOXEN_MYSQL_PORT'] || '3306'
%>

development:
  adapter: mysql2
  encoding: utf8
  database: _development
  pool: 5
  username: root
  password:
  host: localhost
<% if socket %>
  socket: <%= socket %>
<% else %>
  port: <%= port %>
<% end %>

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  adapter: mysql2
  encoding: utf8
  database: _test
  pool: 5
  username: root
  password:
  host: localhost
<% if socket %>
  socket: <%= socket %>
<% else %>
  port: <%= port %>
<% end %>

production:
  adapter: mysql2
  encoding: utf8
  database: _production
  pool: 5
  username: root
  password:
  host: localhost
  socket: <%= socket %>