Remote connect to clearDB heroku database

by

In heroku website, go to My Apps and select the app on which you have installed ClearDB.

On the top corner click on Addons and then select ClearDB MySQL Database.
Once there, click on your database and choose the ‘Endpoint Information‘ tab. There you see your username/password. The URL to the database can be acquired by running
heroku config --app <YOUR-APP-NAME> in the command line.

In my case, it was something like: mysql://user:pass@us-cdbr-east.cleardb.com/DATABASE?reconnect=true
What you need is this part: us-cdbr-east.cleardb.com

More Related Contents:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. How to increase MySQL connections(max_connections)?
  3. How do you write a case insensitive query for both MySQL and Postgres?
  4. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  5. 1052: Column ‘id’ in field list is ambiguous
  6. How to do a batch insert in MySQL
  7. Count the occurrences of DISTINCT values
  8. Codeigniter – multiple database connections
  9. JOIN queries vs multiple queries
  10. Is the primary key automatically indexed in MySQL?
  11. Storing Data in MySQL as JSON
  12. MySQL stored procedures use them or not to use them
  13. MySql: MyISAM vs. Inno DB! [closed]
  14. Cast int to varchar
  15. MySQL: Cloning a MySQL database on the same MySql instance
  16. DOs and DONTs for Indexes [closed]
  17. How to change the default port of mysql from 3306 to 3360
  18. “where 1=1” statement [duplicate]
  19. Meaning of “n:m” and “1:n” in database design
  20. How to set a MySQL row to READ-ONLY?
  21. mySQL – Create a New Table Using Data and Columns from Three Tables
  22. Case Sensitive collation in MySQL
  23. Can’t import database through phpmyadmin file size too large
  24. Strings as Primary Keys in MYSQL Database [closed]
  25. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  26. What is the best way to do incremental backups in MySQL?
  27. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  28. How to Get True Size of MySQL Database?
  29. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  30. MySQL: Computed Column

Leave a Comment