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.