Unable to connect Maria DB remotely with Navicat

Hello ,

I am able to connect to ERPNext with SSH via Puttly (Port 22) . But when i am trying to connect to database with “Navicat” i have no success .


Have you tried to connect via SSH in navicat, there should be a preference to do so. As an example using Sequel Pro on Mac

Hi and welcome @manasayub

FWIW I run ERPNext instances in VMs connected in a bridge network, and access each MySQL instance from MySQL Workbench

To enable access I changed the bind-address here:

frappe@erpnext:~/frappe-bench$ sudo find /etc/mysql -name my.cnf | xargs grep bind-address
#bind-address =
bind-address =

As this explains https://dev.mysql.com/doc/refman/5.7/en/server-options.html

If the address is, the server accepts TCP/IP connections on all server host IPv4 interfaces.

hope this helps