Remote Access to ClearDB MySQL Database on Heroku

Querying a ClearDB MySQL database remotely can be achieved through tools like MySQL Query Browser. To establish the connection, you'll need the following information:

Acquiring Database Credentials and Connection Details:

1. Navigate to the Heroku website and select "My Apps."
2. Choose the app associated with the ClearDB database.
3. Click on "Addons" and select "ClearDB MySQL Database."
4. Select the desired database and navigate to the "Endpoint Information" tab.
5. You will find the username and password needed to connect to the database.

Determining the Database URL:

1. Open your command line and enter the following:

   heroku config --app 

2. Replace with the actual name of your Heroku app.

3. The output will include a line similar to:

   CLEARDB_DATABASE_URL: mysql://user:[email protected]/DATABASE?reconnect=true

4. The database URL is the part that begins with "us-cdbr-east.cleardb.com".

Establishing the Remote Connection:

1. Launch MySQL Query Browser.
2. Enter the database URL, username, and password obtained in the previous steps.
3. Click on the "Connect" button to establish a remote connection to your ClearDB database.