7 Comments on Lost Clip-Bucket’s admin user. How to create a new one from phpMyAdmin

  1. This actually answered my drawback, thank you!

  2. Aslam Ahmed says:

    Thanks for this great information, As it has not been mentioned anywhere else in script documentation ( how to change/retrieve admin pass).

  3. Anthony says:

    I think something has changed in the newer versions of clipbucket. WHen I try to do this I get the folowing error:

    #1054 – Unknown column ‘rating’ in ‘field list’

  4. Hello,

    Use this query: INSERT INTO `cb_users` (`userid`, `category`, `featured_video`, `username`, `user_session_key`, `user_session_code`, `password`, `email`, `usr_status`, `msg_notify`, `avatar`, `avatar_url`, `sex`, `dob`, `country`, `level`, `avcode`, `doj`, `last_logged`, `num_visits`, `session`, `ip`, `signup_ip`, `time_zone`, `featured`, `featured_date`, `profile_hits`, `total_watched`, `total_videos`, `total_comments`, `comments_count`, `ban_status`, `upload`, `subscribers`, `total_subscriptions`, `background`, `background_color`, `background_url`, `background_repeat`, `background_attachement`, `total_groups`, `last_active`,`banned_users`, `welcome_email_sent`, `total_downloads`) VALUES
    (999999, 0, ”, ‘newadmin4133’, ‘22534c8bbf0b3759bb67a667777bfe2e’, 88714, ’38d8e594a1ddbd29fdba0de385d4fefa’, ‘admin@mynewadmin.com’, ‘Ok’, ‘yes’, ”, ”, ‘male’, ‘1989-10-14’, ‘GB’, 1, ‘646f80433c’, ‘0000-00-00 00:00:00’, ‘0000-00-00 00:00:00’, 0, ”, ”, ”, 0, ‘No’, ‘0000-00-00 00:00:00’, 0, 0, 0, 0, 0, ‘no’, ‘1’, ‘0’, 0, ”, ”, ”, ‘repeat’, ‘no’, 0, ‘0000-00-00 00:00:00’, ”, ‘yes’, 0)

    I’ll write a new article for the new version.


  5. Chesare says:

    login as “root” in your CB server,
    log into mysql as root ( mysql -u root -p),
    use your CB DBase,
    do — UPDATE cb_users set password=md5(md5(sha1(sha1(md5(‘your-new-password’))))) where username=’admin’;

    • Richi González says:

      That would work if they didn’t change the way passwords are encoded. Also remember to change username=’admin’, to your admin account.


  6. Laurence F. says:

    Very nice post, Thanks for this publishing. Really help me a lot.

Leave a Reply

Your email address will not be published. Required fields are marked *