bench icon indicating copy to clipboard operation
bench copied to clipboard

Possibility of installing new site without DB root access

Open klau2005 opened this issue 1 year ago • 1 comments

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.

klau2005 avatar Jan 08 '24 17:01 klau2005