Geek Answers Handbook

How to get MySQL CloudFoundry connection parameters?

I deployed the Spring application to CloudFoundry with the MySQL service. I want to connect to this CloudFoundry MySQL instance from MySQL Workbench / QueryBrowser.

Is there any way to get connection parameters (driver, url, username, password) for this mysql db on CloudFoundry?

+4
source share
2 answers

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

eg.

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

(Choose your first choice)

Then open MySQL Query Browser and use the specified username / password. Set the host name to 127.0.0.1 instead of localhost and remember to specify the port number. The default value is 10000.

+5
source

please quickly read please documentation for vmc tunneling here: - http://docs.cloudfoundry.com/tools/vmc/caldecott.html

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

+2
source

More articles:


All Articles