Possibility of installing new site without DB root access

[klau2005]

I want to be able to run the bench new-site command, specifying the DB host and DB name, without requiring root privileges. We can precreate the DB and user with necessary privileges. This way, we can have a preconfigured user with all privileges and we don't need to give the install script root privileges into our DB.

Current workaround: install the site on a local DB (for example, a docker container running mysql/mariadb, where we have root privileges), dump the database, restore it on the remote DB machine where we create the database and user with needed privileges, update the site_config.json site file with the remote DB details.

[andrelohmann]

Hi there, I'm asking myself the exact same question. ERPNext seems to be conceptually a great system, but it seems to be lacing operational exellence. I tryed it with the new-site command by adding options for the previously created database, but it is still asking for root permissions.