June 18, 2005

For Google, Rails on Tiger not reading database.yml

It’s late but I thought I should post this for folks Googling…

If you’re trying to develop a Rails app locally on your Tiger Mac, and it seems like your app isn’t read­ing your user­name and pass­word for your MySQL data­base server, here’s the issue.

Rails ships with a built-​in all-​Ruby MySQL adapter that doesn’t seem to pick up that username/pass. I’m not smart enough to tell you why, but it doesn’t.

So you’ll need to install MySQL, which you can get here.

Then do:

sudo gem install mysql — –with-mysql-dir=/usr/local/mysql

That installs a native-​built MySQL adapter. Your Rails app will pick up the DB config and all will be well with the world.

Update: I should have included the error mes­sage you’ll see. You’ll get some­thing along the lines of this:

Permission denied for use ''@'yourdomain.really.is.here.com' (Using Password: NO)

And you’ll get this despite the fact that you have a user­name and pass­word in the database.yml file.

Filed under: Technology

Next:
Previous:

Related

  • Katie

    Where can I down­load the dic­tio­nary to trans­late all of that? Better yet, give me direc­tions to the library with a hard copy….