#[SOLVED] Is it really needed for Appwrite to have access to the DB root user?

10 messages · Page 1 of 1 (latest)

desert sparrow
#

From what I'm seeing Appwrite has an env var for MariaDB called _APP_DB_ROOT_PASS, but there are other variables for a custom DB user and password, so the thing is if is really needed for appwrite to have access to both the root user and an aditional user specified with the _APP_DB_PASS variable

lapis orbit
#

Appwrite itself never uses that variable as can be seen in the docker-compose.yml file

...
      - _APP_DB_HOST
      - _APP_DB_PORT
      - _APP_DB_SCHEMA
      - _APP_DB_USER
      - _APP_DB_PASS
...
#

The only reason is to set the MariaDB root password in case it needed

#

And, it's best to set it upfront

desert sparrow
lapis orbit
#

No, just put a very strong password

desert sparrow
# lapis orbit No, just put a very strong password

Obviously from the database side I will put a very strong password. The thing is that if I should specify or not that password in the env var. From what I understood, it's not needed specifying the root password, right?

lapis orbit
#

In that case, you can get a warning that you'll need to allow an empty password.

desert sparrow
#

I'm a bit confused 😅

#

Anyways, doing that, specifying there the root password and done