Post by Olly » Mon Sep 11, 2017 4:52 pm

Hello, I was making a lot of changes to my site using opencart. However, those changes weren't showing up on the site. it wasn't getting published. So In the settings I changed my status from Admin to Content developer hoping that might make the difference but now I've lost all admin rights and I'm the only one on the account. There is no other admin accounts in there. I need this fixed. Please help

Newbie

Posts

Joined
Mon Sep 11, 2017 4:49 pm

Post by sachin6609 » Mon Sep 11, 2017 5:59 pm

Hii

You Need To add user in the db with full rights and then login with that

Thanks
Sachin

Active Member

Posts

Joined
Thu Jul 23, 2015 2:57 pm

Post by Olly » Mon Sep 11, 2017 7:37 pm

Okay great. Are you referring to the DB from cpanel? Is there a specific name/ title of that DB?

Newbie

Posts

Joined
Mon Sep 11, 2017 4:49 pm

Post by sachin6609 » Tue Sep 12, 2017 6:52 pm

Hello

Just check the config.php there is a db name which is used by you

You need to go to cpanel then open that Db and go to OC_USER table

there You will find your old username also

Just add here the new username and password and all stuff

Take the db or table backup before you do anything for our side safty

Thanks

Sachin

Active Member

Posts

Joined
Thu Jul 23, 2015 2:57 pm

Post by IP_CAM » Wed Sep 13, 2017 8:49 am

Some general knowledge on resetting Admin Access Data and Access Rights.
Good Luck ;)
Ernie
---
If Admin Password exists, and TopAdmin Rights are valid:
Open Cart Administrator Password Reset tool
http://forum.opencart.com/viewtopic.php ... 32#p592544
---
Direct DB Access, to change Password back to Default:
How to reset my OpenCart Admin Password
http://www.inmotionhosting.com/support/ ... n-password
---
Reset Admin Privileges:
Deleted admin privileges
viewtopic.php?f=190&t=169431
----
MySql QUERY to reset TopAdmin Rights:
Reprint of this Post:
https://web.archive.org/web/20140730141 ... ncart.html
---
Administrator permissions in Opencart
Sometimes altering the permission settings in the admin can have the effect of
locking the top-administrator out of some functions and thereby all access is denied.
If this happens you need to revert to the original permissions that were set on install.
Back database and files up first. Best is you get the installer version and reapply it.
Download the file oc-restore-user-group.sql, then go into the admin and reset
the permissions in user group screen.

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 75 guests