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

Written by Richi González Tuesday, 15 March 2011

Hello,

If for some strange reason you lost your admin user, you can easily create one via any DB manager. For this article, I will show you how to do it with phpMyAdmin. Enjoy!

1. Open up phpMyAdmin from your cPanel.

2. Select the Database you use for Clip-Bucket. (mine is _cbtest)

3. Click the SQL tab located at the top.

4. Copy-Paste the following query. NOTE: If you have a different table prefix rather than cb_, remove the cb_ prefix in the third word to match yours:

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`, `rating`, `rated_by`, `banned_users`, `welcome_email_sent`, `total_downloads`) VALUES
(999999, 0, '', 'newadmin4133', '22534c8bbf0b3759bb67a667777bfe2e', 88714, '38d8e594a1ddbd29fdba0de385d4fefa', '[email protected]', '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', 0, '', '', 'yes', 0)

5. Click Go.

That’s it! You can now test your new account by logging in with: newadmin4133:admin (user:pass). NOTE: I recommend once you log in, to create a new admin account and delete this. This is only for security purposes, it’s up to you if you leave it there, but can be a potential security hole in your website.

Well, I think that’s all, anything you need or a comment you want to leave to me, just do it =).

Best Regards,

Richi

Looking for quality ClipBucket hosting? Try out Arvixe and you won’t be disappointed.

7 Comments

1. Peyton Cairns   |  Tuesday, 12 April 2011 at 5:11 pm

   This actually answered my drawback, thank you!

   
2. Aslam Ahmed   |  Tuesday, 13 September 2011 at 6:54 pm

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

   
3. Anthony   |  Friday, 09 December 2011 at 1:04 am

   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. Richi González   |  Monday, 12 December 2011 at 5:30 pm

   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’, ‘[email protected]’, ‘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.

   Regards,
   Richi

   
5. Chesare   |  Tuesday, 05 June 2012 at 8:49 am

   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’;

   
6. Richi González   |  Tuesday, 05 June 2012 at 2:58 pm

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

   Regards,
   Richi

   
7. Laurence F.   |  Saturday, 15 December 2012 at 12:38 am

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