MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Releases => Topic started by: MRatWork on 2013-02-28, 23:21:35
-
Taken (but modified) from http://forum.lxcenter.org/index.php?t=msg&th=15560 (http://forum.lxcenter.org/index.php?t=msg&th=15560)
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 ('newpassword') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> quit;
service mysqld start
or
sh /script/reset-mysql-root-password <newpassword>
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
Note: code like '<newpassword>' must be change to 'dAFfad13' (for example; not include <>)
-
Thanks for this nice tutorial.
-
thank you
-
When i want to know password to the KloxoMR mysql database (which store KloxoMR configuration), i need to reset MySQL root password using "sh /script/reset-mysql-root-password NewPasswordHere" and then also run "sh /script/fix-program-mysql NewPasswordHere"?
PS: i see i can edit/acess KloxoMR MySQL db also without any password reset from within KloxoMR/Home/SQL Manager. That is usefull. thx