Note: please note that Liferay has renamed its Liferay Experience
Could offerings to Liferay SaaS (formerly LXC) and
Liferay PaaS (formerly LXC-SM).
Issue
- While creating a new DB user, it gets self-deleted upon server restart.
Environment
- Liferay DXP 7.0 +
Resolution
- Please follow the below steps to create a new DB user after logging in as an admin user in MySQL:
create USER <username> identified by '<password>';
grant usage on lportal.* to '<username>'@'%' identified by '<password>';
GRANT ALL PRIVILEGES ON lportal.* TO '<username>'@'%' identified by '<password>';
Flush Priviledges;
- Above steps would create a new user in MySQL DB.
-
Now, navigate to the Environment variables of Liferay and Database service and add the below variable:
LCP_DATABASE_USER_WHITELIST: <username>
Additional Information
- The user gets deleted if the user is not added to the whitelist, as it is a manually created user.
Subscriber Exclusive Content
A Liferay Enterprise Subscription provides access to over 1,500 articles that include best practices, troubleshooting, and other valuable solutions. Sign in for full access.
Sign In