How to change to MYSQL database?

ERPNext
1

I have a Mysql database in the cloud but when I installing erpnext that used MariaDB in localhost.

Thanks & Regards
Rohan Jain

2

You will experience very bad performance if the DB is in the cloud. Rather just use that for backup copies of the DB, but let it run locally

3

But I want my development and database both on different server. So can you please help regarding this.

4

The warning of @trentmu is important. ERPNext and MySQL should either:

  1. Co-exist on the same machine.
  2. Or, share the same local area network (LAN).

Running ERPNext on your laptop/PC, with MySQL hosted in the cloud, is a bad idea.

But here is how you can use a different MariaDB/MySQL server:

  1. Edit file../frappe-bench/sites/common_site_config.json
  2. Find or add:
  • Key: db_host
  • Value: <some ip address>

image