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', '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', 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.
This actually answered my drawback, thank you!
Thanks for this great information, As it has not been mentioned anywhere else in script documentation ( how to change/retrieve admin pass).
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’
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.
Regards,
Richi
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’;
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
Very nice post, Thanks for this publishing. Really help me a lot.