I forgot my admin password :(

Discussion in 'Installation/Configuration' started by badgerbox76, Dec 7, 2006.

  1. badgerbox76

    badgerbox76 New Member

    How can i get back my admin password or make a new one. Thanks
  2. till

    till Super Moderator

    You can set the admin password with e.g. phpmyadmin. Login to the ISPConfig database and change the passwort column in the table sys_user where username = admin to the new password and select "md5" as encryption function.
  3. badgerbox76

    badgerbox76 New Member

    I have not installed phpmyadmin yet so what else can i do?
  4. badgerbox76

    badgerbox76 New Member

    never mind i just reinstalled ispconfig.
  5. till

    till Super Moderator

    Use the commandline mysql client to change the password.
  6. MixMasterMark

    MixMasterMark New Member

    mysql command?

    I get as far as
    >USE ispconfigdb;
    Then I
    I can see the sys_user but I'm not sure of the command. Can you help.

    Thanks in advance. Cheers!
  7. till

    till Super Moderator

    You can update the admin password with this SQL query:

    This resets the password for the user admin to "admin"

Share This Page