Connect erpnext to database

[AbdalAliy]

Remote Database Setup

Hi All, I need some help with configuration and would appreciate if you guys could provide me some guidance or point me to the right direction. I have been struggling these last few weeks to install ERPNext on one server and have the database on another server. I have read through the forum in search of guidance and tried almost everything i found. Adding the below to both the site_config.json and common site did not help also. _“db_host”: “10.0.1.7”, _“db_port”: “3306”, After adding the …

Connect to ERPNext database remotely

Hello, Does anyone know how to connect to ERPNext database from a remote client like Navicat? I am using VirtualBox image downloaded from: Not Found I commented out line: bind-address = localhost from: /etc/mysql/my.cnf and /home/erpnext/frappe-bench/sites/erpnext.erpnext-vm/site_config.json says "db_password": "YeIsGsnvUvQrGC2r" so I tried to view is there any existing remote users with: erpnext@erpnext-vm:~$ mysql --user=erpnext --password=YeIsGsnvUvQrGC2r MariaDB [(none)]> SELECT …

there are already separate discussions in this topic