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).


  • While creating a new DB user, it gets self-deleted upon server restart.


  • Liferay DXP 7.0 +


  • 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:

Additional Information

  • The user gets deleted if the user is not added to the whitelist, as it is a manually created user.
Este artigo foi útil?
Utilizadores que acharam útil: 0 de 0