Create a new database user in Liferay Cloud: Liferay PaaS

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.