Forgot password...anyone know how to reset?

Discussion in 'Installation/Configuration' started by caradeporra, Oct 23, 2007.

  1. caradeporra

    caradeporra New Member

    title explains it. newbie mistake, i know. but i forgot the password after creating. when trying to log in to the mysql db_ispconfig i get the error access denied for user [email protected] any help would be awesome.
  2. caradeporra

    caradeporra New Member

    found it elsewhere...this is what you do

    as root:

    [email protected]:/# mysql db_ispconfig -p
    Enter password: (this will be your sql password)

    then type the following line in. this tells that file to set the password to 'password' in the md5 column for the username 'admin'.

    UPDATE sys_user SET passwort = md5('password') WHERE username = 'admin';

    that will reset your password to: password you can simply replace 'password' at the md5('password') spot to whatever you want if you wish.

Share This Page