Databases

Change databases passwords

Dec 27, 2023, 20:38

View on Discord

Votes

Replies

Participants

Unknown

Messages

D5Original post

Moderator

Jun 27, 2023, 12:23

How I could set a password in the MariaDB database Appwrite has (in the docker container) and in the Redis database?

Summary

User is asking about changing database passwords for Appwrite. They are unsure if InfluxDB stores user data and wants to confirm that MariaDB and Redis are the databases storing user data. There is a link to a GitHub issue related to the topic. They ask if they need to stop the Appwrite instance to set the password and question the purpose of the ENV var for redis password. The response states that for MariaDB, the password can be updated through SQL queries. Appwrite does not work well with a password-required redis. The user asks how to set passwords for MariaDB and Redis in the Appwrite docker container. Solution: To

Drake

Jun 27, 2023, 12:26

If the database has already started, you'll have to update the password like any other mariadb server: by making the SQL queries to update the password.

As for redis, Appwrite doesn't work well with a redis that requires password

Moderator

Jun 27, 2023, 12:26

Then why there's an ENV var to set redis password?

Moderator

Jun 27, 2023, 12:27

If I'm not wrong, I will need to stop the appwrite instance to set the password, true?

Drake

Jun 27, 2023, 12:28

See: https://github.com/appwrite/appwrite/issues/3309#issuecomment-1152775834

Drake

Jun 27, 2023, 12:29

You'll might need to restart after

Moderator

Jun 27, 2023, 12:29

I see

Moderator

Jun 27, 2023, 12:29

Thanks

Moderator

Jun 27, 2023, 12:30

If I'm not wrong the only databases storing user data are both MariaDB and Redis (for caching)?

Moderator

Jun 27, 2023, 12:31

I know there's an additional database (InfluxDB), but that only stores matrics/stats?

Change databases passwords

Need support?_