Resetting password (admin password not accepted any-more)

[JonathanPi]

Hi,
Without doing an update, suddenly Jellyfin didn't accept my password any more. I had Jellyfin open in Firefox and on the same computer on Chrome, because I couldn't cast with Firefox. Login in in Chrome failed, while I used a password manager, so I'm sure it was correct. Maybe it's not possible to log in two times on the same device? I don't know. The forgot-password button said to login from within my home-network. That's not really useful (I was not home and isn't the purpose of Jellyfin exactly to reach your movies from everywhere??).
I have Jellyfin on a Raspberry Pi. The datafiles where not in /var/lib/jellyfin/data/ or /root/.local/share/jellyfin or root/.config/jellyfin. I didn't find the authentication.json file anywhere.
Thanks to ChatGPT I found Jellyfin is using a MySQL DB and how to reset my password from there.

I share my solution here, to help people with the same problem.

Code:

sudo sqlite3 /var/lib/jellyfin/data/jellyfin.db

Code:

SELECT Id, Username FROM Users;

(copy the ID from the admin user)

Code:

UPDATE Users SET Password = NULL WHERE Id = 'paste here your copied ID';
.quit
sudo systemctl restart jellyfin

After that, login without filling in a password and in the settings create a new one.

Good luck!

(I still wonder how suddenly the password isn't accepted anymore and also wonder why the reset button isn't more useful)