Connecting SQLYog or DBVisualizer with ERPNEXT

[Abhinav_Singh]

How can i connect the applications such as SQLYog or DBVisualizer with ERP NExt?

[saurabh6790]

You will find db name and db password under ~/frappe-bench/sites/<your-site-name>/site_config.json

[trentmu]

Database access on Virtual machine

Use SSH tunneling with your favourite GUI and/or terminal app. If you’re on WinX, try putty+HeidiSQL (both free) - something like this work 100% - just tune the address:port, and user/pwd settings to your requirements [DB-puttyHeidi]