Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 Error 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.

share|improve this question

1 Answer 1

up vote 3 down vote accepted

I don't think the root MySQL password had anything to do with my issues. To solve this I found my current ispconfig mysql account password here.

vi /usr/local/ispconfig/server/lib/config.inc.php

...
$conf['db_password'] = 'VERYLONGPASSWORDSTRING';
...

I then reset the MySQL ispconfig account password.

mysql -u root -p
mysql> use mysql
mysql> update User set Password = PASSWORD('VERYLONGPASSWORDSTRING') WHERE User = 'ispconfig';

I could then correctly get through the ISPConfig login page.

share|improve this answer
    
Had the same issue today, your solution worked like a charm! –  davil Oct 1 '12 at 17:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.