I forgot my admin password :(

[badgerbox76]

How can i get back my admin password or make a new one. Thanks

[till]

You can set the admin password with e.g. phpmyadmin. Login to the ISPConfig database and change the passwort column in the table sys_user where username = admin to the new password and select "md5" as encryption function.

[badgerbox76]

I have not installed phpmyadmin yet so what else can i do?

[badgerbox76]

never mind i just reinstalled ispconfig.

[till]

I have not installed phpmyadmin yet so what else can i do?

Use the commandline mysql client to change the password.

[MixMasterMark]

I get as far as
>USE ispconfigdb;
Then I
>SHOW TABLES;
I can see the sys_user but I'm not sure of the command. Can you help.

Thanks in advance. Cheers!

[till]

You can update the admin password with this SQL query:

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

This resets the password for the user admin to "admin"