I have a cluster created with Cloudera Director. Every database, including the Hue DB is external, and I think all the credentials were generated by Director. Now I'd like to add users using the Hue shell or some other script, but it asks for the Hue secrets, that are set in the Manager, but they are secured.
- How can I check these generated users/passwords for the databases?
- If I have the password, what's the easiest way to add Hue users programatically?
thanks for the answer! I could find the Hue DB creds in the API, but for some reason I'm still unable to connect to the database. I'm trying to connect with the following command, with the configs returned by the API:
mysql -h <database_host> -u <database_user> -p <database_name>
and giving the <database_password> when prompted. Also tried without specifying the <database_name>, but no luck, getting Access Denied every time. Is there something I miss?