Warning: Accessing the production database should not be done lightly, it should be avoided as much as possible.
Please be aware any ticket raised relating to issues following direct database changes may incur support charges.
To access the production database you need to have SSH access setup to the production server. If you haven't got this please see: SSH Access
This guide will demonstrate the process of setting up access to the production database via an SSH tunnel. We will be using MySQL Workbench in this example but any database client that supports SSH tunnels will also work.
- From the homepage of MySQL Workbench, click "New Connection"
- Change Connection Name to "Production MySQL Access"
- Change Connection Method to "Standard TCP/IP over SSH"
- Fill out the SSH credentials, this will be the same as direct SSH access credentials. (SSH Access Credentials)
- Fill out the MySQL credentials. These can be gathered by SSH'ing into the production site, and inspecting app/etc/env.php
- Click "Test Connection"
- Click "Okay"