Connecting RHCLOUD on WorkBench

gistfile1.txt

Works on a Fedora 18 box.

You need your ssh login string located in the your OpenShift web portal app.

Example: ssh [email protected]

Mysql Workbench settings:

Select: Standard TCP/IP over SSH

SSH USER = 49698459484EXAMPLE

SSH HOSTNAME = example-example.rhcloud.com

SSH KEYFILE = /home/user/.ssh/id_rsa.pub (or your location of your ssh key)

MYSQL HOSTNAME = ip address

NOTE: SSH into your openshift app account | cd .env | cat OPENSHIFT_MYSQL_DB_URL | = mysql://user:pass@ip-address:port#

MYSQL SERVER PORT = 3306

USERNAME = user

PASSWORD = pass (store in keychain)

Test connection and save. It should work.