If you are using MDOQ's managed Magento hosting or if you are just using MDOQ as your deployment pipeline, during development or issue investigation you may require access to the databse for the instance. (accessing MySQL / database access). If you require access to the production database please refer to Accessing Production Database.
By default the databse cannot be accessed externally, this is a security feature of MDOQ. However there are many ways you can securely connect to your database.
- The easiest and simplest option is simply to use the "MySQL Helper". This is a fully web based UI that allows you to interact with your database however you wish. To access this, (within MDOQ) simply select your instance, click "Helpers", then click on the link to open the helper.
(N.B if you are working with third party developers that don't have an account within MDOQ you can share this URL with them)
- You can use the cli to access the database, after SSH'ing into the instance, you can use `mysql` to access the database (you will need to use the host, username and password credentials that can be found in app/etc/env.php)
- You can use MySQL workbench, this is similar to the previous method and is descibed in Accessing Production Database
If you are struggling to access the database please get in touch and we can advise.