The database connection configuration is part of every
environment.
The configuration file config/database.yml
holds the connection information:
my-project_environment: adapter: mysql database: rails-db username: rails-db-user password: rails-db-user-password socket: /var/run/mysqld/mysqld.sock
You can adjust the entries according to your needs. We strongly advise against using the same database for more than one environment.
The following commands can be used to create a MySQL database:
$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 275 Server version: 5.0.37 MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database Rails-DB; Query OK, 1 row affected (0.00 sec) mysql> grant all on Rails-DB.* to 'Rails-DB-User'@'localhost' identified by 'Rails-DB-User-Password'; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye