I am switching to Databasus for backing up my databases. Postgres has been fine but on two separate mariadb databases, Databasus cannot create read only users. Everything is on docker compose on separate stacks with a bridge network backup-db between the database containers and Databasus.
I think the problem is that the normal user only has permission for the single database but not universal, so have something I can try but I can’t seem to actually login to the databases with the root passwords set in .env a long time ago (along with the normal user / pw which seen to be used fine by the apps). My Nextcloud database is one of the issues. The root PW env variable is the one taken from there database documentation.
Trying to access through “docker exec -it <db_container_name> mariadb -u root -p”
I have already tried setting the -h flag as localhost, 127.0.0.1, <db_container_name> and <nextcloud_app_container_name>.
I tried changing the root PW too.
Any help would be greatly appreciated!
Are you trying with the correct db user? Try connecting to image with the root user for MariaDB and create a new user with permissions. I’ve had to do similar things with Postgres, connecting with the user psql with success.
I can’t seem to login to the root user on two different mariadb databases to make those changes so must be doing something wrong
This description leaves many holes. So either someone succeeds with guessing, or you need someone to interact with you for analyzing step by step what’s really going on there.
My guess is that you need to use the right user on the right system, because “env” exists only in the context of one certain user on one certain (virtual or real) system.