OnCommand Workflow Automation 5.1

Upgrade MySQL


You can upgrade new versions of MySQL for OnCommand Workflow Automation (WFA) on the Windows server. You can upgrade to a newer version of MySQL to get fixes for security vulnerabilities on the Windows server.

You must have Windows admin privileges and the password for MYSQL root user on the WFA server.

Note Before reinstalling WFA 4.2 or later, you must have deleted the MySQL data directory if you have uninstalled MySQL.

You should be aware of the following limitations:

  • You can upgrade within any version of MySQL 5.7.

    For example, you can upgrade from MySQL 5.7.1 to MySQL 5.7.2.

  • You cannot upgrade from MySQL 5.7 to MySQL 5.8

  1. Log in as the admin user on the WFA host machine.

  2. Download the appropriate version of MySQL to the target system.

  3. Use the Windows Services console to stop the following WFA services:

    • NetApp WFA Database or MYSQL57

    • NetApp WFA Server

  4. Click on the MYSQL msi package to invoke the upgrade of MySQL.

  5. Follow the instructions on the screen to complete MySQL installation.

  6. Start the WFA services by using the Windows Services console.