I want from ide to work with the mysql site. I downloaded the image for the virtualbox VMBitrix, built on cent os, it raised a test Bitrix template, set up a static ip address in the system, set phpmyadmin.

When trying to connect from ide, a Communication link failure fails. An example of how to connect below:

connection example

  • Unsolicited advice: do mysqldump from the combat base on the site, deploy a dump on a local test base - and experiment on it. At least for the sake of backup, please dump. - DimXenon
  • I believe that the base simply does not listen to external network interfaces for security reasons. But it depends on the VM'ki you are using. Without knowing who made it and for what reasons, it is difficult to speculate. - D-side
  • @ D-side and the ide window is correctly filled with a host for example? Connect to it via ip? - Ilya
  • one
    If I am right and the DB does not listen to external interfaces , then it is wrong. Well ... more precisely, as correctly as the situation allows , but it will not work if either (a) does not ask the DB to listen to the connections outside (which is dangerous, because it is easy to give too much access), or (b) to connect through the tunnel (SSH?) so that for the machine this connection looks like a connection through a local loop. - D-side

1 answer 1

You need to connect to start with a server with a virtual machine over SSH , and only then connect to a local (from the point of view of the virtual) database. Through PhpStorm you have to register the connection data on the SSH tab, and then on the main tab you connect to the database via localhost . Similarly, the connection to the database in MySQL Workbench configured, first to the server via SSH , then via localhost to the database.