Unable to connect Maria DB remotely with Navicat

ERPNext
1

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 .

2

@manasayub

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

27 pm
27 pm900×1068 88.1 KB

3

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 = 127.0.0.1
bind-address = 0.0.0.0

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

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

hope this helps