Change Password via SSH

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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s