FAQforge

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;

1. Plume says:

   December 4, 2009 at 10:52 pm

   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.

   Reply
2. abubin says:

   January 14, 2010 at 3:52 am

   there is a typo.

   passwort should be password

   Reply
   • Till says:

     January 14, 2010 at 8:23 am

     Thats no typo, the database field is named passwort with “t”. In german, the word password is passwort.

     Reply
3. serge023 says:

   February 23, 2010 at 1:34 am

   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

   Reply
4. serge023 says:

   February 23, 2010 at 1:47 am

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

   Reply
5. Till says:

   February 23, 2010 at 8:54 am

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

   Reply