I forgot my admin password :(

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

  1. badgerbox76

    badgerbox76 Member

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

    till Super Moderator Staff Member ISPConfig Developer

    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 Member

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

    badgerbox76 Member

    never mind i just reinstalled ispconfig.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    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
    >SHOW TABLES;
    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 Staff Member ISPConfig Developer

    You can update the admin password with this SQL query:

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

Share This Page