How to get access to mysql database

1. bosh ssh onto the database instance
2. sudo su -
3. bosh manifest and locate the ccdb password. If the environment is using CredHub (such as one of our bosh-lites) you can either:
   1. look up this password in CredHub: https://github.com/cloudfoundry/capi-release/blob/develop/scripts/mysql-bosh-lite (this script has an example)
   2. find it in /var/vcap/jobs/mysql/config/mariadb_ctl_config.yml
4. /var/vcap/packages/mariadb/bin/mysql -ucloud_controller -p"PASSWORD" -P 3306 -h sql-db.service.cf.internal cloud_controller