I am running ISPConfig 3 under CentOS and I had to manually reset my MySQL root account password yesterday. Since resetting the password I haven't been able to login to ISPConfig's web interface with any account including my admin one.
If I try to login with username: admin and my password I get
Username or Password wrong.
I reset my MySQL root password.
mysqladmin -u root -p'oldpass' password 'roottest'
I logged into MySQL and reset admin password to test.
mysql -u root -p'roottest' mysql> use dbispconfig; mysql> database changed mysql> update sys_user set passwort = md5('admintest') WHERE username = 'admin'; Query OK, 1 row affected (0.07 sec) Rows matched: 1 Changed: 1 Warnings: 0
I changed my mysql_clientdb.conf to the new password.
vi /usr/local/ispconfig/server/lib/mysql_clientdb.conf <?php $clientdb_host = 'localhost'; $clientdb_user = 'root'; $clientdb_password = 'roottest'; ?>
I couldn't find a way to restart ISPConfig 3, or if it's even possible.
The same error from the ISPConfig login page still shows up when trying to login with u: admin p: admintest.