# Database error when running Test

**URL:** <https://discuss.rubyonrails.org/t/database-error-when-running-test/16451>\
**Category:** rubyonrails-talk\
**Created:** [August 1, 2007, 6:21am UTC](https://discuss.rubyonrails.org/t/database-error-when-running-test/16451 "2007-08-01T06:21:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cammo](https://avatars.discourse-cdn.com/v4/letter/c/e19b73/32.png) [@cammo](https://discuss.rubyonrails.org/u/cammo)\
**Post date:** [August 1, 2007, 6:21am UTC](https://discuss.rubyonrails.org/t/database-error-when-running-test/16451/1 "2007-08-01T06:21:39Z")

</div>

Hey, You'll need to setup a test database as well if your trying to run Unit Tests etc. Rails uses different DB's for dev, test and production

Convention would be the following: test: &nbsp;&nbsp;&nbsp;adapter: mysql &nbsp;&nbsp;&nbsp;database: emporium\_test &nbsp;&nbsp;&nbsp;username: root &nbsp;&nbsp;&nbsp;password: root &nbsp;&nbsp;&nbsp;host: localhost &nbsp;&nbsp;&nbsp;socket: /Applications/MAMP/tmp/mysql/mysql.sock

Add that to you database.yml file first and then make a new DB called emporium\_test and all should be fine.

Cam

Al Cholic wrote: