Skip to main content

Change Database Passwords for MySQL

Warning

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

  1. If you have not done so already, switch to the MySQL user and launch:

    sudo su - mysql
mysql

  2. 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>';
ALTER USER 'trifactaauthorizationservice'@'localhost' IDENTIFIED BY '<new_pwd>';
ALTER USER 'trifactaorchestrationservice'@'localhost' IDENTIFIED BY '<new_pwd>';
ALTER USER 'trifactaoptimizerservice'@'localhost' IDENTIFIED BY '<new_pwd>';
ALTER USER 'trifactasecuretokenservice'@'localhost' IDENTIFIED BY '<new_pwd>';
ALTER USER 'trifactaconnectorconfigservice'@'localhost' IDENTIFIED BY '<new_pwd>';

  3. Exit:

    \q
exit

Change in Alteryx configuration

  1. You can apply this change through the Admin Settings Page (recommended) or trifacta-conf.json. For more information, see Platform Configuration Methods.

  2. Modify the user and password properties for any of the following databases:

    Database Name

    Parameter area

    Alteryx database

    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

    artifact-storage-service.database.*

    Job Metadata Service database

    job-metadata-service.database.*

    Authorization Service database

    authorization-service.database.*

    Orchestration Service database

    orchestration-service.database.*

    Optimizer Service database

    optimizer-service.database.*

    Secure Token Service database

    secure-token-service.database.*

    Connector Configuration Service database

    connector-configuration-service.database.*

    For more information, see Database Parameter Reference.

  3. Save your changes and restart the platform.

In this section: