Admin locked out - Printable Version

Admin locked out - Printable Version

+- Jellyfin Forum (https://forum.jellyfin.org)
+-- Forum: Support (https://forum.jellyfin.org/f-support)
+--- Forum: Troubleshooting (https://forum.jellyfin.org/f-troubleshooting)
+--- Thread: Admin locked out (/t-admin-locked-out)

Admin locked out - Brenton - 2025-09-14

So I forgot my password of the only admin account while fixing mums account away from home. I tried to log in to mine but forgot the password or entered it wrong. Now I have tried to reset the password with the pin it creates and it accepts it but when trying to log into the account with the pin it doesn’t work. Just says I don’t have access or something along those lines. I have found the system.xml but am unable to find the <isstartupwizzardcomplete> line among the shapes and words. Is there any other way to fix this?

RE: Admin locked out - IndianaLarry - 2025-09-17

Do you have any other accounts on the setup that you can log into? I ran into this problem when I migrated my setup, and solved it by editing the database to give one of my other users admin privileges and utilizing that to fix things. It required some SQL, but it got me back in.

Specifically, I got into the data/jellyfin.db file, and ran the following:

Code:
update permissions set value = 1 where kind = 0;

What this did is find all AdminUser permission records (kind = 0, as per the source code) and set the value to 1, making all users admins. I then used the UI to revoke this once I got everything fixed.

If you want to limit which users you make an administrator, you can find the user ID and limit by that. For example, by running:

Code:
select id, username from users;

You can get all user IDs:

Code:
Id|Username

2E5D96A1-16C7-4DFE-ACCB-CC4A61CA9DDE|larry

1657A98C-3C21-4873-8BEE-37C6D3D34D27|bob

CEBDB97C-7205-49BB-80A8-F19351AE1B3E|junior

00B3D1B5-BDC0-4447-A7B9-007960DEEF0D|guest

You can then run the first query with the additional filter of the user ID. For example, to make just "guest" the admin:

Code:
update permissions set value = 1 where kind = 0 and userid = '00B3D1B5-BDC0-4447-A7B9-007960DEEF0D';

More details can be found in Jellyfin's Troubleshooting documentation. Note that I recommend stopping the server entirely before you edit the jellyfin.db file.