Reply To: Password reset

[Sepehr]

Hi
You can reset the MikroWizard panel admin password directly from the PostgreSQL database by updating the users table manually.
Example for resetting the default mikrowizard admin account password:

UPDATE public.users
SET password = '$pbkdf2-sha256$29000$yVnr/d9b6917j7G2tlYqRQ$.8fbnLorUGGt6z8SZK9t7Q5WHrRnmKIYL.RW5IkyZLo'
WHERE username = 'mikrowizard';

This will reset the password to the default password ( mikrowizard ) configured during installation.
You can run the query using psql or directly from PostgreSQL tools such as pgAdmin.

If the user was deleted accidentally, it can also be recreated manually using:

INSERT INTO public.users(
    id,
    username,
    password,
    first_name,
    last_name,
    email,
    role,
    adminperms
)
VALUES (
    '37cc36e0-afec-4545-9219-94655805868b',
    'mikrowizard',
    '$pbkdf2-sha256$29000$yVnr/d9b6917j7G2tlYqRQ$.8fbnLorUGGt6z8SZK9t7Q5WHrRnmKIYL.RW5IkyZLo',
    'admin',
    'admin',
    'admin@localhost',
    'admin',
    '{"device": "full", "device_group": "full", "task": "full", "backup": "full", "snippet": "full", "accounting": "full", "authentication": "full", "users": "full", "permissions": "full", "settings": "full", "system_backup": "full"}'
);

you can also change manully password field to “$pbkdf2-sha256$29000$yVnr/d9b6917j7G2tlYqRQ$.8fbnLorUGGt6z8SZK9t7Q5WHrRnmKIYL.RW5IkyZLo”
it will set to mikrowizard