How to connect to the server via a local network through dbForge Studio for MySQL, or HeidiSQL, or Navicat for MySQL? Or maybe there is something simpler?

    2 answers 2

    The /etc/mysql/my.cnf in /etc/mysql/my.cnf . There is a section responsible for listening interfaces:

     bind-address = 0.0.0.0 # слушать все интерфейсы

    Read more: --bind-address = addr .

    • You can not write this, as this is the default value. @ Victor54, check the skip-networking option in the config, it should not be (checked out) - Dex

    Saw in mysql workbench the ability to connect via ssh. Those. you will connect to the base over ssh, look, maybe there is such an option.

    If not, then on the mysql server in the config it is necessary to allow listening to other network interfaces besides the local one so that it can be connected via the Internet or lan.

    • Thank. On lokalkhost problem is not. Server comp1, you need to connect to it with comp2. To be honest, I do not know where to look for the config. - Victor 1