MySQLServer

Description

The MySQL Server plugin lets you manage databases and users on your MySQL Server instance. It supports creating databases, creating users, resetting passwords, and unlocking user accounts. The plugin connects using a hostname, port, username, and password. Use this plugin when your workflows need to automate MySQL administration tasks like database provisioning, user management, or account maintenance.

Compatibility

• MySQL Server - instance and access details, Version 8.0.18 for 64 bit

Prerequisites • MySQL-connector-java-8.0.28.jar must be present in the lib folder of Process Studio as well as AutomationEdge Agent.

Known Errors For Server Port field if any random value is provided then it might not throw a proper error, as there is no validation done for this field to be an integer only.

Common Buttons

Field Name	Description
OK	On click of this button. It will check the field values. If any required field values are missing, then it will display validation error message.If all the required field values are provided then it will save the field values.
Cancel	On click of this button, it will cancel the window and do not save any values.