1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Sitebuilder Lost ADMIN Password :(

Discussion in 'Legacy Sitebuilder Software' started by Rookie, Jun 29, 2005.

  1. Rookie

    Rookie Guest

    0
     
    I know, I'm a dummy :(

    I have lost my ADMIN password... How can I get in to the ADMIN area to change it, reset it or retreve it...

    Thanks
     
  2. jinxedworld

    jinxedworld Guest

    0
     
    A bit late, but maybe someone else can use this.

    If you can still access the SiteBuilder database the following can fix it for you:

    Here is a default hash in 'pswd' column for default password ('sitebuilder')
    mysql> select * from sb_users;
    +----+-------+------------------+------+------------+---------+
    | id | login | pswd | role | createtime | sb_type |
    +----+-------+------------------+------+------------+---------+
    | 1 | root | 35cafb7a7a7ea2ff | 1 | 0 | 1 |
    +----+-------+------------------+------+------------+---------+
    1 row in set (0.02 sec)

    So, you need you run following query:

    mysql> update sb_users set pswd='35cafb7a7a7ea2ff' where id=1;

    Now login to sitebuilder with user 'root' and password 'sitebuilder' and you're good to go!
     
  3. Rookie

    Rookie Guest

    0
     
    Hi jinxedworld,
    Thanks for the reply.

    I did manage to find my password in the end but this will be a great one to keep for future refrence :)

    Awsome! Thanks jinxedworld
     
  4. Jeronimo

    Jeronimo Guest

    0
     
    Hi 2 All.
    For such users like Rookie :) in SiteBuilder3.0 will be a 'feature' "Forget Password".
     
  5. Netcontac

    Netcontac Basic Pleskian

    23
    57%
    Joined:
    Aug 15, 2005
    Messages:
    49
    Likes Received:
    0
    Hello,

    I had tried to recover my password and I am missing something :confused:

    Following the FAQ I enter this command:

    mysql> mysql -usb_user -psb_user sitebuilder -e

    Then:

    --> update sb_users set pswd=password('new_password') where id=1

    After that, it remains the promt:

    -->

    I leave this shell using ^Q and nothing happens.

    Please let me know what I am doing wrong.

    Greetings
     
  6. luribe

    luribe Guest

    0
     
    Is pswd='35cafb7a7a7ea2ff' where id=1; and not password('new _password').

    And you miss a ; at the end of the line
     
Loading...