Using HeidiSQL to access ERPNext database?

AntonyNaude · February 17, 2020, 7:10am

Can I use HeidiSQL to remote access my ERPNext database?

trentmu · February 17, 2020, 8:26am

Yes. Best option is to install and use putty along with HeidiSQL via SSH tunnel

AntonyNaude · February 17, 2020, 11:11am

Hi Trent, is there an idiots guide somewhere I can refer too?

AntonyNaude · February 17, 2020, 11:16am

I have not accessed ERPNext remotely before, I’m used too MariaDB hosted in the cloud, etc. No problems there.

AntonyNaude · February 18, 2020, 6:23am

I have created a test DB with ERPNext, I have HeidiSQL and Putty.
What do I do in ERPN to get connected.
What type of SSL key should I create using Putty, etc.

trentmu · February 18, 2020, 3:08pm

I use the 2 something like this…

The password in the left box is the mysql DB password for the user (root in this example).
The password on the right box is the password for your erpnext/frappe user

vpp · January 3, 2021, 12:56pm

@trentmu - Thanks for the instructions and screenshots. This work for me.