Remote mysql database on Heroku app

by

This is old but in case anyone drops around looking for an answer, it’s much easier than using the gem. Just provide a DATABASE_URL and SHARED_DATABASE_URL (not sure if the second is needed). The database url format is adapter://username:password@hostname:port/database, so for example, you would do: 

heroku config:add DATABASE_URL=mysql://etok:somepassword@<your-server>:3306/etok
heroku config:add SHARED_DATABASE_URL=mysql://etok:[email protected]:3306/etok

Then re-deploy your app. It will read your DATABASE_URL and generate the database.yml from that. The default port is already 3306 so it’s not needed in the url in your case. When you deploy, you may notice that it generates your database.yml: 

-----> Writing config/database.yml to read from DATABASE_URL

Then you’re set (as long as your server accepts connections from your heroku host.

More Related Contents:

  1. Heroku push rejected, no Cedar-supported app detected
  2. How to fix the uninitialized constant Rake::DSL problem on Heroku?
  3. Can’t find the ‘libpq-fe.h header when trying to install pg gem
  4. No route matches “/users/sign_out” devise rails 3
  5. Build vs new in Rails 3
  6. Heroku deployment error H10 (App crashed)
  7. PG undefinedtable error relation users does not exist
  8. Rails DB Migration – How To Drop a Table?
  9. Rails 3: Get Random Record
  10. Setting session timeout in Rails 3
  11. Rails .where vs .find
  12. Devise form within a different controller
  13. Is it possible to set ENV variables for rails development environment in my code?
  14. Devise limit one session per user at a time
  15. Heroku upload-Precompiling assets failed
  16. belongs_to through associations
  17. Using Rails link_to for links that post
  18. Rails 3 disabling session cookies
  19. Extending controllers of a Rails 3 Engine in the main app
  20. Rails naming convention for join table
  21. simple hit counter for page views in rails
  22. Rails 3 check if attribute changed
  23. Access helpers from mailer?
  24. Rails 3 autoload
  25. How can I solve this trouble to deploy a Rails App to Heroku?
  26. Index on multiple columns in Ruby on Rails
  27. Ruby on rails 4 app does not work in iframe
  28. Rails 3.1 include_root_in_json
  29. Rails: Order with nulls last
  30. Why should we avoid using class variables @@ in rails?

Leave a Comment