Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2018-02-25, 10:22:02

Author Topic: [TIP] Reset Password  (Read 7841 times)

0 Members and 1 Guest are viewing this topic.

Online MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +113/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
[TIP] Reset Password
« on: 2013-02-28, 23:21:35 »
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 <>)
« Last Edit: 1970-01-01, 01:00:00 by Guest »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline befree22

  • Valuable Member
  • *
  • Posts: 95
  • Karma: +0/-1
    • View Profile
Re: [TIP] Reset Password
« Reply #1 on: 2014-02-25, 05:07:19 »
Thanks for this nice tutorial.

Offline amudy17

  • Senior Member
  • *
  • Posts: 246
  • Karma: +0/-1
    • View Profile
    • Alamudy
Re: [TIP] Reset Password
« Reply #2 on: 2014-03-14, 23:49:59 »
thank you
Free, Fast and Secure CP => Kloxo-MR
Daily News Update => Click here to see website!

Offline postcd

  • Junior Member
  • *
  • Posts: 23
  • Karma: +0/-0
    • View Profile
Re: [TIP] Reset Password
« Reply #3 on: 2017-04-16, 11:52:08 »
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
« Last Edit: 2017-04-16, 12:00:29 by postcd »

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix
Click Here

Page created in 0.133 seconds with 20 queries.

web stats analysis