Cloudera Docs

Configuring MySQL as the backend database for Cloudera Data Explorer (Hue)

After installing and configuring the MySQL database, you can configure Data Explorer to use it as its backend database.

  1. Log into Cloudera Manager as an Administrator.
  2. Go to Clusters > service > Configuration and filter by Database category.
  3. Select the Hue Database Type as MySQL.
  4. Set the following database parameters:
    Hue Database Hostname: FQDN of host running MySQL server
    Hue Database Port: 3306
    Hue Database Username: [***USERNAME***]
    Hue Database Password: [***PASSWORD***]
    Hue Database Name: [***HUE-DATABASE-NAME***] or SID
  5. Click Save Changes.
  6. Restart the Data Explorer service.
You can click Data Explorer (Hue) Web UI to log on to Data Explorer with a custom MySQL database.