1. Change root password:
su - root
passwd


2. Mysql root password: --> ERROR 1045 (28000): Access denied for user 'root'@'localhost'
service mysqld stop

mysqld_safe --skip-grant-tables &
mysql -u root

mysql>
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD ('yournewpassword') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> quit;

service mysqld start


3. Kloxo admin password login:
sh /script/resetpassword master {newpassword}


4. Reset Kloxo mysql password: --> Error "Could not open database connection." when access to Kloxo
sh /script/fix-program-mysql {mysqlrootpassword}

or, enough:
sh /script/fix-program-mysql


5. Reset Horde password: --> Error "Could not open database connection."
Open file:
cat /home/kloxo/httpd/webmail/horde/config/conf.php

then find lines something like:
$conf['sql']['username'] = 'horde_groupware';
$conf['sql']['password'] = 'aVBq4yOrS';

then run:
service mysqld stop

mysqld_safe --skip-grant-tables &
mysql -u root

mysql>
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD ('aVBq4yOrS') WHERE User='horde_groupware';
mysql> FLUSH PRIVILEGES;
mysql> quit;

service mysqld start

Or enough:
sh /script/fixhorde


6. Reset Roundcube password: --> Error "Could not open database connection."
Open file:
cat /home/kloxo/httpd/webmail/roundcube/config/db.inc.php

then find line something like:
$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';

then run:
service mysqld stop

mysqld_safe --skip-grant-tables &
mysql -u root

mysql>
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD ('pass') WHERE User='roundcube';
mysql> FLUSH PRIVILEGES;
mysql> quit;

service mysqld start

Note: Roundcube password always set as 'pass' (without quote).