Erpnext db server n workbench in on my virtual box, i just installed mysql workbench on the virtualbox since erpnext is using mariadb (innodb).
I setup as usual jdbc connection to the virtual box IP and the erpnext db name, like following :
I using jdbc connecting my localhost db working well… is it the way / approach to do it for erpnext ?
I solve this issue myself, the problem is to allow remote access to db. Find the mysql folder, then my.conf , then edit the value 127.0.0.1 to 0.0.0.0 which means allow remote access and follow the step from these link How to Allow MySQL Remote Access in Ubuntu Server
IF you hit user and privilege issue, then follow this link : mysql - Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) - Stack Overflow