0

I am working on a project based on Magento Commerce Cloud.

Can anyone please guide on how can i access DB of staging branch.

Thanks!

1

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.

  • Can you configure something like dbeaver to connect to mysql across a ssh tunnel? – Dominic Xigen Jun 11 at 0:25
  • I'm not familiar with dbeaver but once the tunnel is open (via the cli tool), any client should be able to connect through it. magento-cloud tunnel:info will give the connection information which would have a port on localhost to connect to as well as a username and password if it is staging or production. – Billy Gilbert Jun 11 at 16:15
0

Try:

SSH to the Integration environment.

magento-cloud ssh

Connect to the database.

mysql -h <db-host> -P <db-port> -p -u <db-user> <db-name>
  • Thanks.Do we have any option other than terminal ? – venki May 21 at 14:06
  • I think no, as this is managed by aws. I'll update if I got any solution in future – Saphal Jha May 21 at 14:11
0

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:info will give the connection information

https://dbeaver.io/

Connect to MySQL server in Dbeaver

Create new connection button

Select MySQL

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.