Pivotal Knowledge Base

Follow

How to Connect to the PCF Elastic Runtime internal MySQL database

Environment

Product Version
Pivotal Cloud Foundry® (PCF) 1.6.x , 1.7.x

Purpose

This article discusses how to connect to PCF Elastic Runtime internal MySQL database. PCF uses this database to store information for UAADB, Apps Manager DB, CCDB, App Usage Events DB, Autoscaling, and Notifications. 

Procedure

Follow the steps below within the Elastic Runtime Tile of Ops Manager:

  1. Depending on your configuration, you can connect directly to one of the many nodes in the cluster and not the proxy node. Select the Status tab and retrieve the IP from the specific MySQL Server node
  2. Select the Credentials tab and retrieve the Mysql Admin Credentials from MySQL Server
  3. SSH into Ops Manager or a VM that has direct access to the MySQL DB Node and has the MySQL client installed.
  4. Run the following command mysql -h <ip> -u root -p where the IP is retrieved from step 1 above. The password will be prompted after you select enter.

Additional Information 

Here are a few popular MySQL commands:

  • To list database type the following command at MySQL prompt:

         mysql> show databases; (this displays database)

  • To use the database and to enlist the available tables type, here are two commands:

         mysql> use mysql;
         mysql> show tables;

Also, link to the bootstrap docs as they instruct you to run commands to check the status of the cluster.

https://docs.pivotal.io/pivotalcf/1-7/customizing/mysql_bootstrap_ert.html

Comments

Powered by Zendesk