# MySQL. Versions 5.6.4 and up are supported. # # Install the MySQL driver # gem install trilogy # # Ensure the MySQL gem is defined in your Gemfile # gem “trilogy” # # And be sure to use new-style password hashing: # dev.mysql.com/doc/refman/5.7/en/password-hashing.html # default: &default
adapter: trilogy
encoding: utf8mb4
max_connections: <%%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
username: root
password:
host: <%%= ENV.fetch("DB_HOST") { "<%= database.host %>" } %>
development:
<<: *default
<% if database.socket -%>
socket: <%= database.socket %>
<% end -%>
database: <%= app_name %>_development
# 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:
<<: *default
<% if database.socket -%>
socket: <%= database.socket %>
<% end -%>
database: <%= app_name %>_test
# As with config/credentials.yml, you never want to store sensitive information, # like your database password, in your source code. If your source code is # ever seen by anyone, they now have access to your database. # # Instead, provide the password or a full connection URL as an environment # variable when you boot the app. For example: # # DATABASE_URL=“trilogy://myuser:mypass@localhost/somedatabase” # # If the connection URL is provided in the special DATABASE_URL environment # variable, Rails will automatically merge its configuration values on top of # the values provided in this file. Alternatively, you can specify a connection # URL environment variable explicitly: # # production: # url: <%%= ENV %> # <%- unless options.skip_solid? -%> # Connection URLs for non-primary databases can also be configured using # environment variables. The variable name is formed by concatenating the # connection name with ‘_DATABASE_URL`. For example: # # CACHE_DATABASE_URL=“trilogy://cacheuser:cachepass@localhost/cachedatabase” # <%- end -%> # Read guides.rubyonrails.org/configuring.html#configuring-a-database # for a full overview on how database connection configuration can be specified. # <%- if options.skip_solid? -%> production:
<<: *default database: <%= app_name %>_production username: <%= app_name %> password: <%%= ENV["<%= app_name.upcase %>_DATABASE_PASSWORD"] %>
<%- else -%> production:
primary: &primary_production <<: *default database: <%= app_name %>_production username: <%= app_name %> password: <%%= ENV["<%= app_name.upcase %>_DATABASE_PASSWORD"] %> cache: <<: *primary_production database: <%= app_name %>_production_cache migrations_paths: db/cache_migrate queue: <<: *primary_production database: <%= app_name %>_production_queue migrations_paths: db/queue_migrate <%- unless options.skip_action_cable? -%> cable: <<: *primary_production database: <%= app_name %>_production_cable migrations_paths: db/cable_migrate <%- end -%>
<%- end -%>