Text and meaning of the error
The following message may occur when trying to connect to a MySQL database using the "Connect to database" activity:
Error at Connect to database in main.neek.backup :
Database: Host 'XXXX' is not allowed to connect to this MySQL server
This message appears due to MySQL server settings.
Solution
- Use MySQL Workbench to take a look at server connection parameters, such as DBMS hostname, Database name, etc.
- Make sure you are using the correct hostname and credentials in the "Connect to database" activity.
- Save and run the workflow.