Issue
RPA has the ability to connect to MySQL to use it as a data source for a botflow. First, we have only tested with 32 bit versions so we are not sure a 64 bit version will work.
Next, there are two options regarding versions:
- Use version 8.0.17 which is the one we made the build with.
- Use any version up through 8.0.28 but the connectors, MySQL.Data.dll, Renci.SshNet.dll, and Renci,SshNet.xml, need to be 8.0.17. If you want to use a version of MySQL other than 8.0.17, go to the MySQL Downloads Archives and select the download for version 8.0.17 and only download the connector.
We have tested version 8.0.29 and RPA will not connect with that version.
**If you have installed a newer version than 8.0.17, the installer will not let you install an older version. Provided below is a zipped copy of version 8.0.17 MySQL.Data.dll, Renci.SshNet.dll, and Renci.SshNet.xml. Once unzipped, place them in the C:Program Files (x86)NintexRPA folder then attempt to connect.
Resolution
To connect:
1. Install Nintex RPA Central.
2. Install Nintex Bot.
3. Install MySQL Workbench & MySQL Connector Net following the link Instructions:
https://help.nintex.com/en-us/rpa/Botflow/Data_SQL.htm.
4. Make sure MySQL Services are running correctly.
5. Make sure MySQL Workbench can be connected with username & password.
Additional Information
The Bot needs both the MySQL.Data.dll and Renci.sshNet.dll in the C:Program Files (x86)NintexRPA folder. If they are not there, check the C:Program Files (x86)MySQLConnector NET 8.0Assembliesv4.5.2. folder for the files and copy them to the RPA folder.
Also, double-check that the port matches the one set up when connected through Workbench. Port 3306 is the standard MySQL port but it's possible it was configured to use a different port.