How to Create a New Clip-Bucket v2 Admin Account When You Have Lost Your Password

Written by Richi González Saturday, 31 December 2011

Hello,

I wrote an article some time ago explaining how to create a new admin account in the case you had lost your current password; however, that article works only for previous versions, so here I write one for the new v2.x. (See the other article)

You will need access to a DB manager. In this example, I use phpMyAdmin.

Difficulty level: Easy

1. Open phpMyAdmin from your cPanel

2. Select the Database you use for CB. In this example I will use DB: _cbtest

3. Click on SQL, located at the top navigation.

4. Copy-paste this query: (IF YOUR TABLE PREFIX IS NOT ‘CB_‘,  CHANGE IT)

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)

5. Click Go.

And guess what? You have created a new admin user! Log in with newadmin4133:admin (user:pass). Once you log in, either create a new admin account and delete this one, or change password. Just one last thing…don’t forget your password!

Best Regards,

Richi

Owner of Juapo2Services

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

Related posts:

1. Lost Clip-Bucket’s admin user. How to create a new one from phpMyAdmin
2. How to Change the Password of Your Elgg Admin Account
3. How to Set an Age Requirement to Register in Clip-Bucket v2.x
4. How to Disable Photos in Clip-Bucket v2.5
5. How to Manually Approve Videos Before They Are Shown in Clip-Bucket v2.x

1 Comment

1. STEEL   |  Thursday, 05 January 2012 at 9:55 pm

   I see it helps Btw i love the new theme u gave me on my Arvixe account for phpmyadmin