ERPNext reset database

Install / Update Deployment
1

I have deployed ERPNext on Google Cloud using Bitnami. I just have two questions. How to reset the database and delete everything and start fresh setup?

Also, How to access the database?

Thanks in advance :blush:

2

You can use bench reinstall to reset and start all over.

To access the db, you can do bench mysql.

5 Likes
3

Should i direct to a location to run this command? Because i run it and it didn’t work.

4

Any and all bench commands need to be performed as the erp user (e.g. erpnext) and executed in the bench directory (e.g. frappe-bench). Don’t use sudo as this will cause issues as well. Instead sudo su to the erp user. e.g.

myregularuser@host:~$ sudo su - erpnext
erpnext@host:~$ cd frappe-bench
erpnext@host:~/frappe-bench$ bench reinstall
erpnext@host:~/frappe-bench$ bench mysql
6 Likes
5

I am speechless. Thank you very much. This helped me with my problem.

1 Like