===== Prepare Database Access =====
Your Brightbox comes with access to a shared MYSQL database cluster. The migration recipes check the format of ''database.yml'' for the environment you are deploying to and will warn you if there is information missing, or in the wrong format

== Edit the database.yml file ==

Edit your ''database.yml'' and alter the ''production'' section to the following:
<code>
  production:
    adapter: mysql
    host: sqlreadwrite.brightbox.net
    username: <your database user name>
    password: <your database password>
    database: <your database user name>_<your application name>_<configuration section>
</code>
You'll find the database username and password on the [[https://www.brightbox.co.uk/customer/login|Brightbox control panel]]

The 'application name' is a short name for your application that differentiates this application database from all the others stored under your Mysql username. 

So, for example, if you have a database user name of ''fred'' and an application called ''myforum'' then your ''production'' section would look like this.
<code>
  production:
    host: sqlreadwrite.brightbox.net
    username: fred
    password: a_password
    database: fred_myforum_production
</code>

 
[[docs:gemv2:howto|Back to Index]]