Friday, October 7, 2011

Setup Rails2 with Remote MySQL Database

  1. Install the MySQL adapter
    gem install mysql
  2. Open and Edit config/database.yml
    development:
      adapter: mysql
      database: yourDBName
      host: xxx.xxx.xxx.xxx or hostName
      username: yourUserName
      password: yourPass
      port: 3306 or other
    

If running rake you get an Error message containing 'development database is not configured (activerecord::adapternotspecified)' this depend from a typo or extra-tab. Check accurately your database.yml.