By default for demonstration purposes, Liferay DXP/Portal is configured to use an embedded HSQL database. Beyond demonstration purposes, we recommend using a full-featured, supported RDBMS, such as:
The Liferay DXP Compatibility Matrix lists the supported databases and versions.
Create a database that uses UTF-8. Here is a MySQL command example:
create database lportal character set utf8;
Set up a database user with full database permissions. If your organization requires the DXP database user to have limited database access, see High Security Database User Practices.important
Liferay requires reading from and writing to the database. The Liferay database user must therefore have permissions to read and write data.
Install a JDBC Connector. The DXP bundle includes several open source JDBC connectors in the
$CATALINA_BASE/webapps/ROOT/WEB-INF/shielded-container-libfolder (in the
$CATALINA_BASE/lib/extfolder for previous versions of Liferay). Connectors for proprietary database, like Oracle or DB2 (see the table below), must be downloaded from the vendor.
Congratulations! You configured a database for Liferay DXP.
For database configuration details, see the Database Configuration Reference.