Selfhosted

60526 readers

1349 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Detailed Rules Post

Be civil.
No spam.
Posts are to be related to self-hosting.
Don't duplicate the full text of your blog or readme if you're providing a link.
Submission headline should match the article title.
No trolling.
Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details.
AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post.

Resources:

selfh.st Newsletter and index of selfhosted software and apps
awesome-selfhosted software
awesome-sysadmin resources
Self-Hosted Podcast from Jupiter Broadcasting

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago

MODERATORS

curbstickle@anarchist.nexus

curbstickle_lw@lemmy.world

Help with MariaDB root login (feddit.uk)

submitted 1 month ago by brewery@feddit.uk to c/selfhosted@lemmy.world

4 comments fedilink hide all child comments

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!

you are viewing a single comment's thread
view the rest of the comments

[–] brewery@feddit.uk 1 points 1 month ago (1 children)

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

[–] captcha_incorrect@lemmy.world 1 points 1 month ago

If you copy the DB file to your computer, you should be able to inspect them with some kind of viewer. Perhaps you can figure out the username/password that way?