Beberapa waktu lalu, saya mengalami error dalam masuk ke admin kloxo mr.
Mau tidak mau saya harus melakukan reset admin.
dan script ini yang bekerja
Taken (but modified) from http://forum.lxcenter.org/index.php?t=msg&th=15560
1. Change root password:
Code: [Select]
su – root
passwd
2. Mysql root password: –> ERROR 1045 (28000): Access denied for user ‘root’@’localhost’
Code: [Select]
service mysqld stop
mysqld_safe –skip-grant-tables &
mysql -u root
mysql>
mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD (‘newpassword’) WHERE User=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit;
service mysqld start
or
Code: [Select]
sh /script/reset-mysql-root-password <newpassword>
3. Kloxo admin password login:
Code: [Select]
sh /script/resetpassword master <newpassword>
4. Reset Kloxo mysql password: –> Error “Could not open database connection.” when access to Kloxo
Code: [Select]
sh /script/fix-program-mysql <mysqlrootpassword>
or, enough:
Code: [Select]
sh /script/fix-program-mysql
Note: code like ‘<newpassword>’ must be change to ‘dAFfad13’ (for example; not include <>)
Alhamdulillah bekerja
namun di artikel lain nemu juga seperti ini:
sh /script/fix-program-mysql PASSWORD
sh /script/reset-mysql-root-password PASSWORD
sh /script/resetpassword master PASSWORD
Silakan pilih, mana yang cocok. Semoga sukses ya…