Database Access
Access databases across various environments.
Database Credentials
- The following environment variables store database credentials:
APP_DB_PASSWORD
DB_HOST
APP_DB_NAME
APP_DB_USERNAME
You can view the values of these variables by running the following command via SSH on the CLI:
env | grep DB
Database Access via CLI
To access the database via the command line, use the following command:
mysql -h ${DB_HOST} -u${APP_DB_USERNAME} -p${APP_DB_PASSWORD} ${APP_DB_NAME}GUI Access Options
MySQL Workbench or other GUI Clients
- Connect using Standard TCP/IP over SSH connection method with these details:
- SSH Hostname:
access.gcp.lon1.x.x.cfstack.com:[port_number]
- SSH Username:
web
- SSH Key File: Use your private SSH key file
- MySQL Hostname:
mariadb
- MySQL Server Port:
3306
- Username:
application
- Password: To retrieve the password, use the Database Credentials section above.
After configuring these settings, you'll be able to connect to the database using MySQL Workbench.
PHPMyAdmin
We can provide secure access to PHPMyAdmin behind a whitelisted firewall.
Please get in touch with our team using the Corefinity ticketing system or Slack for PHPMyAdmin access.
Did this answer your question?
😞
😐
🤩