Skip to main content

What can we help you with?

The "Host 'XXXX' is not allowed to connect to this MySQL server" error

Fernando Sabatini
  • Updated

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

  1. Use MySQL Workbench to take a look at server connection parameters, such as DBMS hostname, Database name, etc.
    data.png
  2. Make sure you are using the correct hostname and credentials in the "Connect to database" activity.
  3. Save and run the workflow.