View Single Post
Old 24th October 2011, 16:32
mistr_e mistr_e is offline
Junior Member
Join Date: Oct 2011
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Default accounts can't login since resetting my MySQL root password

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
$clientdb_host                  = 'localhost';
$clientdb_user                  = 'root';
$clientdb_password              = 'roottest';
I couldn't find a way to restart ISPConfig 3 after these changes, 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.

Help me ISPConfig community, you're my only hope.
Reply With Quote
Sponsored Links