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.