topic Re: Workflow Automation on Linux MySql Default Password in Ask The Experts

Workflow Automation on Linux MySql Default Password

t_johnk — Fri, 21 Feb 2020 21:58:11 GMT

Hi,

How can I find out and change the default mysql root password on a Linux based installation of Workflow Automation?

This would be for both version 4.2 and 5.1. I don't have the current password, nor have I.

Thanks,

John

mbeattie — Wed, 26 Feb 2020 02:54:08 GMT

Hi John,

According to the documentation...

You must have root privileges for the Linux system on which you have installed WFA.
The WFA services must be running.

This procedure resets only the password of the admin user created during the WFA installation.
You cannot reset the password of other WFA admin users that you created after the WFA installation.
This procedure does not enforce the password policy you have configured.
Therefore, you must enter a password that complies with your password policy or change the password from the WFA user interface after you have reset the password.

As a root user, log in to the Linux system on which WFA is installed.
At the shell prompt, navigate to the following directory on the WFA server: WFA_install_location/wfa/bin/
Enter the following command: ./wfa --admin-password [--password=PASS]
If you have not provided a password, you must enter the password when prompted.
At the shell prompt, follow the on-screen instructions.

Hope that helps

/Matt

mbeattie — Wed, 26 Feb 2020 03:01:04 GMT

Hi John,

Sorry just noticed you are trying to reset the MySQL password (not the default WFA admin user).

To reset the MySQL root password see this:

/Matt