Magento Expert Forum - Improve your Magento experience

Results 1 to 5 of 5

How to reset admin password for ISPConfig?

  1. #1
    Moderator speed2x's Avatar
    Join Date
    Mar 2013
    Location
    Hollywood, Florida, United States
    Posts
    88
    Thanks
    8
    Thanked 7 Times in 6 Posts

    Thumbs up How to reset admin password for ISPConfig?

    If you lost your ISPConfig 3 administrator password, you can reset it with the following SQL query.

    Code:
    UPDATE sys_user SET passwort = md5(‘admin’) WHERE username = ‘admin’;
    The SQL query sets the password to “admin” for the user “admin”, it has to be executed in the ISPConfig mysql database, e.g. with phpmyadmin. If you dont have phpmyadmin installed, then the query can be executed with the mysql commandline utility as well:

    Login to the mysql database.

    Code:
    mysql -u root -p
    and enter the password of the mysql root user. To switch to the ISPConfig database, run this command:

    use dbispconfig;

    Now execute the SQL command:

    Code:
    UPDATE sys_user SET passwort = md5(‘admin’) WHERE username = ‘admin’;
    and close the mysql shell:

    Code:
    quit;

    View more threads in the same category:


  2. #2
    Junior Member Kathy Daunt's Avatar
    Join Date
    May 2013
    Posts
    69
    Thanks
    10
    Thanked 4 Times in 4 Posts

    Default

    Thanks. The post was great and found helpful for Magento admins. Keep going with such technical post

    Thanks
    Kathy
    grouponclone.contus.com

  3. #3
    Junior Member
    Join Date
    Sep 2018
    Location
    United Kingdom
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Hi Everyone...

    RESET Admin Password:

    If you lost your ISPConfig 3 administrator password, you can reset it with the following SQL query.

    UPDATE sys_user SET passwort = md5(‘admin’) WHERE username = ‘admin’;

    IF THIS COMMAND DONT WORK BY COPYING , TYPE OUT INSTEAD OF COPYING

    If the above command don’t work try the following:

    The SQL query sets the password to “admin” for the user “admin”, it has to be executed in the ISPConfig mysql database, e.g. with phpmyadmin. If you dont have phpmyadmin installed, then the query can be executed with the mysql commandline utility as well:

    Login to the mysql database.

    mysql -u root -p

    Then enter the password of the mysql root user. To switch to the ISPConfig database, run this command:

    use dbispconfig;

    And execute the SQL command:

    UPDATE sys_user SET passwort = md5(‘admin’) WHERE username = ‘admin’;

    Finally close the mysql shell:

    quit;

    Thanks..

  4. #4
    Junior Member aishwaryaV's Avatar
    Join Date
    Sep 2018
    Location
    Noida, India
    Posts
    31
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    RESET Admin Password:

    If you lost your ISPConfig 3 administrator password, you can reset it with the following SQL query.
    If the above command don't work try the following:
    The SQL query sets the password to “admin” for the user “admin”, it has to be executed in the ISPConfig mysql database, e.g. with phpmyadmin.

  5. #5
    Junior Member
    Join Date
    Sep 2018
    Location
    United Kingdom
    Posts
    487
    Thanks
    0
    Thanked 5 Times in 5 Posts

    Default

    In the event that you lost your ISPConfig 3 director secret phrase, you can reset it with the accompanying SQL inquiry. UPDATE sys_user SET passwort = md5('admin') WHERE username = 'administrator'; The SQL question sets the secret phrase to "administrator" for the client "administrator", it must be executed in the ISPConfig mysql database, for example with phpmyadmin.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •