Modifying database properties

You can modify external database properties such as hostname, port, username, password, and database name using the Cloudera Management Console.

If your cluster was installed using the OpenShift Container Platform, you can view, but not modify the database properties. If the cluster was installed using the Embedded Container Service, you can edit the properties.
  1. Sign in to the CDP console.
  2. Click Management Console.
  3. On the Management Console home page, select Administration>Databases to view the Database administration page.
    The Database administration page displays a list of databases.
  4. Click the Edit icon, located at the right side of each row, for the database you want to modify.
    A dialog box appears where you can modify database properties. For example:
  5. Modify any of the following properties:
    • Username
    • Password
    • Database Host
    • Database Port
    • Database Name
  6. Click the Test Database Connection button to verify that CDP can connect to the database. If the test fails, re-check your modifications and click Test Database Connection again.
  7. Click Save and Restart.
  8. If you have deployed the Cloudera Data Warehouse (CDW) service in your ECS cluster, you must refresh the affected Database Catalogs and Virtual Warehouses from the CDW UI. Go to the CDW UI, click on the more vertical menu on the Database Catalog or Virtual Warehouse and click Refresh.
The database properties are updated.