CODEWITHSUNDEEP
javaspringcloud-foundry
K. Siva Prasad Reddy
K. Siva Prasad Reddy

Reputation: 12405

How to get CloudFoundry MySQL connection parameters?

I have deployed a Spring application on CloudFoundry with MySQL service. I want to connect to that CloudFoundry MySQL instance from MySQL Workbench/QueryBrowser.

Is there a way to get connection params(driver, url, username, password) for that mysql db on CloudFoundry?

Upvotes: 4

Views: 1245

Answers (2)

Nikos Berdos
Nikos Berdos

Reputation: 161

try to connect with cadlecott application (vmc tunnel) to your mysql service. You can use the provided username, password and service name to your MySQL Workbench.

e.g.

vmc create-service mysql mysql-test
vmc tunnel mysql-test
Service connection info: 
  username : u5B3ShwOIX40c
  password : p2VoxZqZQRxTz
  name     : d5dc313431cff4046b68798a8bba1328c

Starting tunnel to mysql-test on port 10000.

**1: none**

2: mysql

3: mysqldump

Which client would you like to start?: 1

( Select the 1st choise)

Then open the MySQL Query Browser and use the above username/password. Set the hostname to 127.0.0.1 instead of localhost and remember to set the port number. The default is 10000.

Upvotes: 5

Dan Higham
Dan Higham

Reputation: 3984

please take a quick read though the documentation for vmc tunnelling here :- http://docs.cloudfoundry.com/tools/vmc/caldecott.html

As Nikos already pointed out, just select option one after connecting the tunnel and then use the supplied parameters to connect MySQL Workbench.

Upvotes: 2

Related Questions