27

So I just finished setting up a JBoss application server gear on Openshift and I attached a MySQL and phpmyadmin cartridges. My question is if there is a way to remote access to the database server using an app like MySQL Workbench?

felipsmartins
  • 13,269
  • 4
  • 48
  • 56
Stephen Rodriguez
  • 1,037
  • 1
  • 12
  • 22
  • essentially but from a remote instead – Stephen Rodriguez Nov 04 '13 at 04:43
  • I think its possible to set up mySQL to allow remote connections without a lot of difficulty. I saw a script years ago that could break into the database without a password however that was on localhost. I would think its possible to connect phpmyadmin using the remote ip address of the SQL server in the config – Adsy2010 Nov 04 '13 at 12:44
  • 1
    haha im not trying to get in trouble here. It should be legal with the right steps. – Stephen Rodriguez Nov 04 '13 at 16:27

5 Answers5

24

You can use rhc port-forward to forward ports from your database to your local machine. Check out the tutorial here. The basic idea of port forwarding in this context is that you can forward ports on your local machine to ones on the gear. So in your case, you would forward some port on your local machine to the port mysql is listening on for connections in your gear. Then you would connect MySQL Workbench to the port on your local machine.

Paul Morie
  • 15,528
  • 9
  • 52
  • 57
23

Use SSH and MysqlWorkbench

SSH commands: (next to rhc ssh myappname)

echo $OPENSHIFT_MYSQL_DB_HOST

echo $OPENSHIFT_MYSQL_DB_PORT

echo $OPENSHIFT_MYSQL_DB_USERNAME

echo $OPENSHIFT_MYSQL_DB_PASSWORD

MysqlWOrkbench

Create new connection:

Set connection name

set connection method: Standard TCP/IP over SSH

Fill SSH hostname = host of yor app, ex: "myappname-user.rhcloud.com"

SSH Username = UUID of your app

SSH Key file = On Windows: C:\Users\XXX.ssh\id_rsa On OS X: /Users/XXX/.ssh/

Click "Test connection" .... and use myqlworkbench

Kaivosukeltaja
  • 15,541
  • 4
  • 40
  • 70
Bhasckar Belo
  • 231
  • 2
  • 3
  • I persoanally prefer this over forwarding a port. Thanks! Also I was putting 127.0.01 as port, but echoing `$OPENSHIFT_MYSQL_DB_HOST` saved the day for me! PS: I've tried with Sequel Pro. – Arda Jun 26 '15 at 15:03
  • I can't believe this worked. Especially on Windows... amazing – Farzher Feb 12 '17 at 11:27
5

The solution is explained here using Linux:

rhc port-forward -a app &

rhc app show -a <app>

mysql -u <user>  -h 127.0.0.1 -P 3307 -p

After entering your password, you are connected with remote mysql on Openshift.

Timo
  • 2,922
  • 3
  • 29
  • 28
4

Login via SSH.

  1. Login for SSH
  2. export | grep MYSQL
  3. View value to OPENSHIFT_MYSQL_DB_HOST and OPENSHIFT_MYSQL_DB_PORT

Example:

[xxxxxxx.rhcloud.com xxxxxxx]\>  export | grep MYSQL
declare -x OPENSHIFT_MYSQL_DB_GEAR_DNS="xxxxxxx-name.rhcloud.com"
declare -x OPENSHIFT_MYSQL_DB_GEAR_UUID="xxxxxxx"
declare -x OPENSHIFT_MYSQL_DB_HOST="xxxxxxx-name.rhcloud.com"
declare -x OPENSHIFT_MYSQL_DB_PASSWORD="nlxxxxxxx"
declare -x OPENSHIFT_MYSQL_DB_PORT="57176"
declare -x OPENSHIFT_MYSQL_DB_URL="mysql://adminxxxxxxx:nlqxxxxxxx-name.rhcloud.com:57176/"
declare -x OPENSHIFT_MYSQL_DB_USERNAME="adminxxxxxxx"
Sergio
  • 2,369
  • 1
  • 15
  • 22
0

To remotely access MySQL on Openshift, you can configure NodePort or LoadBalancer as the type on the Service instead of the default ClusterIP. This will allow external tcp access to your database. Note a nodeport will be defined in the 30000-32767 range by default which will map to the targetport.

user518066
  • 1,277
  • 3
  • 23
  • 35