Submit Feedback
Legacy Knowledge Base
Published Jun. 30, 2025

Liferay PaaS - Can I only access the database through the MySQL Client?

Written By

Tímea Bihari

How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!

While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.

Legacy Article

You are viewing an article from our legacy "FastTrack" publication program, made available for informational purposes. Articles in this program were published without a requirement for independent editing or verification and are provided"as is" without guarantee.

Before using any information from this article, independently verify its suitability for your situation and project.
Note: please note that Liferay has renamed its Liferay Experience Could offerings to Liferay SaaS (formerly LXC) and Liferay PaaS (formerly LXC-SM).

Issue

  • I am using the MySQL client to access the database: Using the MySQL Client
  • The shell access is not user friendly and makes it hard to read the data.
  • Is there any other way to access the database?

Environment

  • Liferay PaaS

Resolution

  • Only the MySQL Client is supported for accessing the database.
  • Connecting from somewhere outside (e.g from a MySQL Workbench on your local PC) is not possible.
  • If your goal is to visualize data you could explore the option of reporting tools. For example, this Marketplace plugin might be an option.
  • Another workaround (enabling offline data browsing) could be generating a backup, downloading it, and opening it with the help of a MySQL client on your local system.

Additional Information

  • Please keep in mind that direct data modification in the DB is strongly discouraged and not supported.
  • If you would like to perform data change, you could run groovy scripts which use Liferay's API from Server Administration > Scripts. It is advised that you take a backup prior to performing such changes, so that you can restore the database in case anything unexpected happens.
Did this article resolve your issue ?
Legacy Knowledge Base
Did this article resolve your issue ?