Thank-You @mcarlton00 that post gave me the pointers to fumble through DB Browser for SQLite GUI and figure it out, all sorted now with a backup hidden admin account lol
For anyone as clueless in SQlite / CLI as I am I will quickly show how I made it work with a SQlite GUI tool, not saying I did it correctly or in the easiest method but its working so…
Stopped my Jellyfin docker and backed up my jellyfin.db file at jellyfin\data\data
Grabbed zipped non install version of DB Browser for SQLite from here
Unzipped and ran “DB Browser for SQLite.exe” and selected “Open Database (open an existing database file)” button then browsed to the jellyfin.db file at jellyfin\data\data of my jelly fin install.
Then I clicked on the “Execute SQL” tab and in tab labeled “SQL 1” entered
select Id from Users where Username = 'your_admin_username';
changing ‘your_admin_username’ text to your Jellyfin username. Then with line highlighted clicked “Execute Current Line” or Shift+F5
In the box below an ID string will pop up similar to below codebox labelled ID, note this string as it will get added to next command.
Returned to “SQL 1” tab from before and at line #2 I entered
Update Permissions set Value = 0 where Kind = 2 and Permission_Permissions_Guid = '7C62F8DF-8453-45E2-BA63-A32EF13B2927';
Remember to insert ID string matching your profile you found first step in place of one in above codebox. Then click the “Execute Current Line” button or Shift+F5 with line #2 selected.
Finally click on the “Write Changes (write changes to database)” button, then “Close Database (close the current database file)”
Now you should be able to start Jellyfin and sign in. Refer to @mcarlton00 above post if you have the CLI tools / skills though likely wouldn’t be needing this to start with lol.
Myself since I had attempted a password reset I had to spawn and fresh reset pin code for my initial sign in and then correct my password and pin in profile settings.