do you grant privileges for db:create and friends?

rubyonrails-talk
1

Before the new db tasks I used as anyone a custom task. It used IO.popen("mysql -u root -p", 'w') to pipe SQL based on ActiveRecord::Base.configurations[RAILS_ENV]. The new db tasks assume the configured user can create and drop databases. Do you people actually grant those privileges?

-- fxn

2

I’d like to know that too.

I assume that most people are going with the root / no-password database.yml defaults… but that’s a really good question.

3

I don't think there's any particular benefit to restricting capabilities on my local dev box. I use the MySQL root user with no password for all my Rails projects. Staging and production are a different matter entirely, of course. :slight_smile:

~ j.