I've screwed up! Password for admin panel etc

Discussion in 'Installation/Configuration' started by helly88, Aug 24, 2012.

  1. helly88

    helly88 Member

    Ok.. Yesterday I changed my root MYSQL password.
    Today just before I was going home from work, I decided to create a ned database using ISPconfig. All seemed fine but in phpmyadmin I could see that the DB hadn't been created. Even tough it was created in ISPconfig.

    Then I got a couple of calls and I had to go. But I didn't.. I tried a couple of thing first (I messed up)...
    I changed the mysql password in the : nano /usr/local/ispconfig/interface/lib/config.inc.php

    That did not help.
    Then I changed the password of ispconfig in users -> ispconfig db.

    All wrong.. I know..

    How the ..... do I go about fixing this? I don't want to screw up anything else.

    Now I can't login to ISPconfig or my mail. I can login to phpmyadmin and via ssh..
  2. helly88

    helly88 Member

    Please. Falco? Till? :) Anybody?

    I can't login to ISPconfig or any of my mails.. Getting kind of desperate.
  3. Monotoba

    Monotoba Member

    I think you can change it via phpmyadmin using MD5 encryption.... Try the sys_user table.
  4. helly88

    helly88 Member

    Yes, I've changed that password. No luck.
    I can't login with any other users either. I think it's because I've changed the password in ISPconfigs config.inc.php file, both server and client.. So I guess ISPconfig (and my mail etc) can't connect to mysql to check if the username / password is correct)

    Should this password also be MD5 encrypted?
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes,you locked yourself out of the mysql database now. Never change the passwords in that files, they are managed by the ispconfig installer and the same password is used for many other servoces like postfix tc as well, so dont change it. You can find the corrrect password in the mysql*...cf config files in /etc/postfix/ directory. Take the password from one of these files and set it again inb the ispconfig config.inc.php file.
  6. helly88

    helly88 Member

    Ok. I've done this.

    But I've also changed the password of the ispconfig user in the mysql database (users).
    I guess I can't just copy the same passowrd into phpmyadmin? It looks too long..
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Copy the password into phpmyadmin, then select "Password" as function for the password column before you save the record. mysql will then encode the password correctly.
  8. helly88

    helly88 Member


    Thank you so much! I'll never ever try to make a quick edit before leaving work, ever again..

Share This Page