Setup a MySQL Database

johnmuhl edited this page Aug 24, 2010 · 1 revision
create database radiant_dev;
create database radiant_test;
create database radiant_production;

grant all on radiant_dev.* to u@'%' identified by 'pw';
grant all on radiant_test.* to u@'%' identified by 'pw';
grant all on radiant_production.* to u@'%' identified by 'pw';
flush privileges;

Where u is the username and pw the password. You’ll need to put these values in config/database.yml.

Your database.yml should look similar to this:

development:
  adapter: mysql
  database: radiant_dev
  username: replace-with-your-username
  password: replace-with-your-password
  socket: /tmp/mysql.sock

test:
  adapter: mysql
  database: radiant_test
  username: replace-with-your-username
  password: replace-with-your-password
  socket: /tmp/mysql.sock

production:
  adapter: mysql
  database: radiant_production
  username: replace-with-your-username
  password: replace-with-your-password
  socket: /tmp/mysql.sock
Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.