Install ISPCONFIG on Debian

apt-get update && apt-get upgrade
apt-get install unzip 
cd /tmp
wget --no-check-certificate https://github.com/servisys/ispconfig_setup/archive/master.zip
unzip master.zip

cd ispconfig_setup-master/
./install.sh

 1. Initially, we login as a root user and find the ISPConfig config file that contains MySQL information.

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

The result looks like,

$conf['db_database'] = 'dbispconfig'

$clientdb_host = ‘localhost’

$clientdb_user = ‘root’

$clientdb_password = ‘Password’

2. After that, we log into the MySQL server from the command line with the information extracted from mysql_clientdb.conf. This helps us to confirm that the password actually works.

mysql -h localhost -p dbispconfig

3. Then we set this password in the MySQL database by running:

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

5. Finally, restart MySQL service.