Home page Forums Technical Support, Bugs and Fixes Password reset Reply To: Password reset

#8841
Sepehr HashtroudilarSepehr
Keymaster

    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