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.
I see it helps 🙂 Btw i love the new theme u gave me on my Arvixe account for phpmyadmin 😀
There’s certainly a great deal to learn about this issue. I like all of the points you have made.
I am actually glad to glance at this web site posts which contains plenty of helpful information, thanks for providing
these statistics.
Good post. I learn something totally new and challenging on websites I stumbleupon everyday.