How to reset the web GUI password? I've tried solutions in issues already.

[JoramMinnaard]

Hey there, as the title states, I'm locked out of my npm instance.

When trying to follow the following instructions:
#1634

I'm getting stuck at the UPDATE user SET is_deleted=1;
That results in the following output:
Parse error: no such table: user

Do you have any suggestions on what I'm doing wrong??
Thanks in advance for any help

[shalafi99]

Hi, before the UPDATE command there should be a command to actually define which db you will run the UPDATE command against.

Did you confirm the correct db has been picked? I never tried this procedure myself nor am that versed with databases, but by reading the instructions it seems to be a 'npm' db in there (there is a step to run 'USE npm')

[JoramMinnaard]

EDIT: I don't know what I have done, but I can login now.
Thanks for the help :)

Thanks for the suggestion.
After I posted this discussion I also looked into the logs.
From that it states the following:

[1/10/2025] [3:25:23 PM] [Global ] › ✖ error create table migrations (id int unsigned not null auto_increment primary key, name varchar(255), batch int, migration_time timestamp) - Table 'migrations' already exists Error: create table migrations (id int unsigned not null auto_increment primary key, name varchar(255), batch int, migration_time timestamp) - Table 'migrations' already exists

Any suggestions?

Kind regards