Hello, randomly out of the blue I was no longer able to log in to mariadb with root via adminer. I tried with phpmyadmin and via the terminal and also no luck. I also tried to edit the root password on the edit page of the docker container but no luck. Here is the exact error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
It would appear normal connections still work. I'm running 2 instances of photoprism and they are running with no issues and connecting to mariadb. I found online there is a way to skip grant tables, flush privileges, and create a new login but I couldn't find a way to do it for lscr.io/linuxserver/mariadb. Is there anyway I can fix this?