What to do if you accidentally delete an administrator user
Written By
Shimada Taro
How To articles are not official guidelines or officially
supporteddocumentation. They are community-contributed content and may
not alwaysreflect the latest updates to Liferay DXP. We welcome your
feedback toimprove How to articles!
While we make every effort to ensure this Knowledge Base is accurate,
itmay not always reflect the most recent updates or official
guidelines.We appreciate your understanding and encourage you to reach
out with anyfeedback or concerns.
Legacy Article
You are viewing an article from our legacy
"FastTrack"publication program, made available for
informational purposes. Articlesin this program were published without a
requirement for independentediting or verification and are provided
"as is" withoutguarantee.
Before using any information from this article, independently verify
itssuitability for your situation and project.
Issue
I accidentally deleted an admin user due to customization.
How should I deal with this?
Environment
DXP 7.0+
solution
How to re-display the setup wizard at first startup and re-register the administrator user. For local environment:
Shut down Liferay
Open LIFERAY_HOME/portal-setup-wizard.propertiesand set "setup.wizard.enabled=true
Restart Liferay
The setup wizard will appear and you will need to reset your user name and password.
Shut down Liferay
Open LIFERAY_HOME/portal-setup-wizard.propertiesand set "setup.wizard.enabled=false
The setup wizard will appear and you will need to reset your user name and password.
Delete the environment variables registered in step 2
Restart the Liferay service
If a general user exists, the method of granting Administrator privileges directly to the user on the database. *Liferay does not recommend direct editing of the database. Also, problems caused by direct editing are not covered bysupport. The following information is provided as a troubleshooting guide, but is not originally recommended. Please consider carefully and implement at your discretion. Obtains the CompanyId of the instance in question. CompanyId can be found on the Company table. From the User_ table, check the users that exist on the instance. select * from user_ where companyId=XXXXXXX; Get the ID of the Administrator authority on the instance from the Role_ table. Replace companyIdwith the ID obtained. select * from role_ where companyId=XXXXX and name ='Administrator'; Insert a record in the Users_Roles table. CompanyId,RoleId,UserIdare replaced with the actual values obtained, respectively. insert into Users_Roles values (CompanyId, RoleId, UserId, 0, NULL);
This website uses cookies and similar tools, some of which are provided by third parties (together “tools”). These tools enable us and the third parties to access and record certain user-related and activity data and to track your interactions with this website. These tools and the informationcollected are used to operate and secure this website, enhance performance, enable certain website features and functionality, analyze and improve website performance, and personalize user experience.
If you click “Accept All”, you allow the deployment of all these tools and collection of the information by us and the third parties for all these purposes.
If you click “Decline All” your IP address and other information may still be collected but only by tools (including third party tools) that are necessary to operate, secure and enable default website features and functionalities. Review and change your preferences by clicking the “Configurations” at any time.