How to reset the administrator password in ISPConfig 3

Friday, November 6, 2009 posted by Till

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';

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

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:

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

and close the mysql shell:

quit;

Share and Enjoy:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Twitter
  • FriendFeed
  • MisterWong
  • StumbleUpon


6 Responses to “How to reset the administrator password in ISPConfig 3”

  1. Plume says:

    I need this help but met some trouble as reply to (UPDATE sys_user SET passwort = md5(’admin’) WHERE username = ‘admin’;) comand:
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘▒▒admin’) WHERE username = ‘admin’’ at line 1
    I fix it by changing your _’_ to my _’_ in text editor but thank you for your help very much :) it realy help me.

  2. abubin says:

    there is a typo.

    passwort should be password

  3. serge023 says:

    mysql> UPDATE sys_user SET password = md5(.admin.) WHERE username = .admin.;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) WHERE username = .admin.’ at line 1
    mysql>

    i seem to be getting the same error but after fixing the typo

    i appreciate any help

    regards
    serge023

  4. serge023 says:

    i try ‘ ” ` and get this santex UPDATE sys_user SET passwort = md5(‘admin’) WHERE username = ‘admin’;
    bash: syntax error near unexpected token `(‘

  5. Till says:

    This is a SQL command. You have to execute it on the mysql commandline or in phpmyadmin and not in bash.

Leave a Reply