Good Day,   Effective January 31, 2021, all Cloudera software requires a valid subscription and is only accessible from behind the paywall. This includes all legacy versions for Cloudera Distribution including Apache Hadoop (CDH), Hortonworks Data Platform(HDP), Data Flow (HDF/CDF),and Cloudera Data Science Workbench (CDSW). Information regarding paywall access will be available in technical documentation by software type and version.   https://www.cloudera.com/downloads/paywall-expansion.html   If you have a valid Cloudera Subscription, you can obtain your credentials for downloads following directions outlined here: https://docs.cloudera.com/cdp-private-cloud-base/latest/installation/topics/cdpdc-cm-download-information.html      ... View more

If Director is creating the database via templates it will append a randomly generated string to the scm prefix so that multiple deployments can use the same database server without naming conflicts.  The user you are using needs full administrative privileges to the entire database instance if going this route.     If you are wanting to specify a pre-created database name and user, and only provide the user access to that one database, you will need to make sure to use something like the example in the attached link and deploy your environments via a conf file.   https://www.cloudera.com/documentation/director/latest/topics/director_external_db_using.html   cloudera-manager { # ... databases { CLOUDERA_MANAGER { name: scm1 type: mysql host: 1.2.3.4 port: 3306 user: scmuser password: scmpassword } # ... } } type - The type of database, “MYSQL” or “POSTGRESQL.” hostname - The name of the server host. port - The listening port of the server. name - The name of the database on the server. username - The name of the user account having full access to the database. password - The password for the user account. Hope this helps! ... View more

  It looks like your scm user doesn't have proper privileges to access the database server. This could be a problem with the grants in your mysql instance.   [2019-03-14 23:36:19.504 +0500] INFO [io-thread-6] - - - - - ssh:10.142.0.54: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'scm'@'%' to database 'scm_lsq85p3anqialkp12nogfhig3j' [2019-03-14 23:36:19.504 +0500] INFO [io-thread-6] - - - - - ssh:10.142.0.54: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.8.0_181] Cloudera Altus Director requires a username with full access to the database.   https://www.cloudera.com/documentation/director/latest/topics/director_external_db_using.html   ... View more