Do you grant privileges for db:create and friends?

Rails
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

On Dec 14, 2007 8:03 PM, Brian H. [email protected] wrote:

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.

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.

3

I’d like to know that too.

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