Forum Discussion

BIsteht's avatar
BIsteht
Helper III
7 years ago

Unable to Connect to MySQL Database

I am having all kinds of issues when trying to connect to a MySQL database in the following scenario:

 

Enterprise Gateway on Windows 10 desktop

MySQL database on Linux box

 

I can connect to the database from the machine hosting the gateway using MySQL Workbench no problem. I can also connect to the datebase using Power BI desktop from outside of the corporate network as well. When I add my datasource to the Gateway the PBI service initially shows everything works fine. However, as soon as I manually refresh or run a scheduled refresh an error is thrown showing invalid credentials. Then the connection eventually gets blocked due to too many failed attempts to connect.

 

Any ideas?

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi BIsteht,

     

    Please check if the MySQL database server and on-premises data gateway are in a same domain or in the same local network. In addtion, please also check if the on-premises data gateway service is still running on the server.

     

    Regards,

    Jimmy Tao

    • BIsteht's avatar
      BIsteht
      Helper III
      7 years ago

      v-yuta-msft What are the requirements for domain and network configuration when working with MySQL or any other database? Can you provide those details or point me to a support article with the information. I can take that and work to solve the issue.

       

      Thanks!