You should change the passwords for the Alteryx® databases immediately after installing the software.
Please complete the following steps to change the passwords for the Designer Cloud Powered by Trifacta platform users of the Alteryx databases.
Change in Database Server
If you have not done so already, switch to the MySQL user and launch:
sudo su - mysql mysql
For each database, change the default password. Default usernames are listed for each database. Please modify the command if you are using different roles and insert a more secure password for
<new_pwd>
:NOTE: In MySQL, the dash is a forbidden character in usernames. Please use underscores instead.
ALTER USER 'trifacta'@'localhost' IDENTIFIED BY '<new_pwd>'; ALTER USER 'trifactaactiviti'@'localhost' IDENTIFIED BY '<new_pwd>'; ALTER USER 'trifactaschedulingservice'@'localhost' IDENTIFIED BY '<new_pwd>'; ALTER USER 'trifactatimebasedtriggerservice'@'localhost' IDENTIFIED BY '<new_pwd>'; ALTER USER 'trifactaconfigurationservice'@'localhost' IDENTIFIED BY '<new_pwd>'; ALTER USER 'trifactasartifactstorageservice'@'localhost' IDENTIFIED BY '<new_pwd>'; ALTER USER 'trifactajobmetadataservice'@'localhost' IDENTIFIED BY '<new_pwd>';
Exit:
\q exit
You can apply this change through the Admin Settings Page (recommended) or Modify the Alteryx database Artifact Storage Service database For more information, see Database Parameter Reference.Change in Alteryx configuration
trifacta-conf.json
.
For more information, see Platform Configuration Methods.user
and password
properties for any of the following databases:Database Name Parameter area webapp.database.*
Jobs database batch-job-runner.database.*
Scheduling database scheduling-service.database.*
Time-based Trigger database time-based-trigger-service.database.*
Configuration Service database configuration-service.database.*
artifact-storage-service.database.*
Job Metadata Service database job-metadata-service.database.*
This page has no comments.