Change MySQL Reset/Update Password – Root SSH – Kullanıcı ve Şifre İşlemleri

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