I am working on a project based on Magento Commerce Cloud.
Can anyone please guide on how can i access DB of staging branch.
SSH to the Integration environment.
Connect to the database.
mysql -h <db-host> -P <db-port> -p -u <db-user> <db-name>
If your goal is to access it using some type of GUI client, you could accomplish this by opening an ssh tunnel using the
magento-cloud utility, similar to the above answer:
magento-cloud tunnel-open --project=<PROJECT_ID> --environment=staging
Then run the command
magento-cloud tunnel:info to get the appropriate credentials to input into whatever utility you may be trying to use.
I use dbeaver software. It gives you a visual editor
Once the tunnel is open (via the cli tool), any client should be able to connect through it.
magento-cloud tunnel:infowill give the connection information
Connect to MySQL server in Dbeaver
Create new connection button
In the ‘General’ window this is ‘User name’ and ‘Password’ for databse
User name: MYSQL user name you want to use
Password: Password of the MYSQL user
When you have already filled the required fields click to Next button. After it the second important window appears:
First of all click to the checkbox icon ‘Use SSH Tunnel’ to gain access to the settings. Fields you have to fill in the right way:
HOST/IP: IP of details shown by magento command
User Name: ssh connection user name you want to use as tunnel to MySQL connection
Authentication Method: ‘Public Key’
Private Key: Path of the private key on your PC
Password: ssh tunnel connection password
If everything has configured correctly when you click to ‘Test Connection’ a confirmation message box will appear.