LEARN HOW TO RESET THE ISPCONFIG3 ADMIN ACCOUNT PASSWORD IN 3 MINUTES!

In this 3 minutes video tutorial you will learn how to quickly regain access to your ISPCONFIG3 admin user account thats if you have lost or forgotten the password. Losing or forgetting a password can be very frustrating especially during moments when you urgently and really need to get some work done. However this video is here to rescue you from such as situation and demonstrate how you can quicky regain access to your ISPCONFIG3 dashboard administrator account using the ISPCONFIG3 ssh terminal.

REQUIREMENTS

In order to complete this tutorial, the following is a list of items that may be needed or required. Please ensure to have these items available before taking implementation action on this tutorial to ensure success:
1) A desktop or laptop with 4GB RAM, a dual core processor and 50GB of free disk space
2) A physical/virtual or cloud hosted server running ispconfig3 server software
3) A ssh client such as putty, terraterm or the MACOS / LINUX terminal app
4) the password for the root user on the ispconfig3 server
5) the mysql root account password

OVERVIEW

1) Connect to the ISPCONFIG3 server via SSH and copy the mysql root password
2) Connect to the MARIADB shell and log in using the mysql root password
3) Run a mysql database update command to update the ISPCONFIG3 admin account password
4) Open the ISPCONFIG3 web based dashboard and log in using the password that you set in the mysql update command.

STEP 1: Connect to the ISPCONFIG3 server via SSH and copy the mysql root password

1) Open up your SSH client app so you can connect to the ISPCONFIG3 server’s terminal. If you are using the MACOS or LINUX terminal app the command you need to run to connect is:

ssh username@ip-address-of-ispconfig-server.

If your ISPCONFIG server is deployed in the cloud on a service such as AWS. You first need to download the key pair file for the server and change the permissions on the key pair file to read only by running the following command:

chmod 400 key-pair-file-for-ispconfig3-server.pem

Once you have done this run the following command to connect to the server via SSH:

ssh -i ‘key-pair-file.pm’ username@ip-address-of-ispconfig3-server

2) If you are using a Windows pc, download the putty application from putty.org. Install putty onto your computer and once installed open the app. On the CONNECT TO field, type in the IP address of the ISPCONFIG3 server and ensure that the port you are connecting to is set to 22. Click on connect and type in the root password for the ISPCONFIG3 server.

3) You now need to copy the root MYSQL password and you can copy it by running the following commands:

apt install nano

nano /usr/local/ispconfig/server/lib/mysql_clientdb.conf

4) Once you have copied the MYSQL password, run the following command to login into the MYSQL server and connect to the ispconfig database:

mysql -h localhost -p dbispconfig

Paste or type in the password that you copied in the previous step then run the following command to update the ISPCONFIG3 admin password:

UPDATE sys_user SET passwort = md5('YourNewPassword') WHERE username = 'admin';
FLUSH PRIVILEGES;
quit;

5) Once you have done this, open up a new web browser tab and browse to the login page for your ISPCONFIG3 server. Type the username admin and the password that you set in the previous step and click on LOGIN.

6) You should now be successfully logged into your ISPCONFIG3 dashboard.