bench
bench copied to clipboard
Possibility of installing new site without DB root access
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.