Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 24th October 2011, 15: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.

Code:
mysqladmin -u root -p'oldpass' password 'roottest'
I logged into MySQL and reset admin password to test.

Code:
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.

Code:
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 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
 

Bookmarks

Tags
centos, ispconfig, mysql, password, root

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Webmail jacksmerv Installation/Configuration 13 12th January 2011 14:03
Perfect Server Ubuntu 9.10 ISPConfig2 AppArmor Issue dwtj01 HOWTO-Related Questions 9 18th November 2009 13:47
Postfix email server problems Access denied 554 554 5.7.1 state 14 AceRimmer Server Operation 4 19th June 2008 14:36
Apache2 Freezes celtic Server Operation 31 28th May 2007 17:18
cannot connect to ispconfig guidovanh Installation/Configuration 22 3rd March 2006 19:52


All times are GMT +2. The time now is 14:51.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.