3 Replies Latest reply on Apr 11, 2017 1:16 AM by tlichtenberger-2 RSS
    tlichtenberger-2 Explorer

    Error connecting to the MySQL server

    Hi all!

     

    I have set up an MySQLServer and a database with a table named tblAircrafts. I tried to create a service (respectively a query) to query

    the whole table, but I am getting following error:

     

    Error executing Service

    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Unable to Invoke Service queryAircrafts on MySQLDatabase_Pilot : null, message from server: "Host 'GSPC130805.test-fuchs.com' is not allowed to connect to this MySQL Server"

     

     

    I do not know why the host isnt allowed to connect to the server. I first thought it would be able to establish a connection because I have seen it in the "lastConnected" attribute. It established an Connection as I set up the MySQLConnection-Thing:

     

    My query-Service looks like followed:

    Maybe some of you have come across the same problem?

    I would appreciate any help or advice you can give me. Thank you so much in advance!