Configuring MySQL as the backend database for Hue

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

  1. Log into Cloudera Manager as an Administrator.
  2. Go to Clusters > Hue 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 Hue service.
You can click Hue Web UI to log on to Hue with a custom MySQL database.