Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Connection problems with MySql database

Good morning to all
It happens that I am trying to connect to a server that was installed xampp as a database manager, at the time of making the connection it indicates the following error:

 

 

Already try to make the modification from options and settings> data source settings, with the domain account and the user of the database and nothing I can not connect successfully.

I greatly appreciate if you can help me with this problem.

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

    Firstly, are you able to connect to the database through MySQL workbench? Make sure that MySQL workbench is installed on the same machine with Power BI Desktop. If the connection fails, please follow the guide in this blog to troubleshoot this issue.

    Secondly, if you are able to connect to database using MySQL workbench, please use same connection parameters in Power BI Desktop, and also add port number with server name to connect to MySQL.

    Thirdly, ensure that you install MySQL Connector/Net 6.6.5 for Microsoft Windows on your computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).

    Thanks,
    Lydia Zhang

  • Anonymous's avatar
    Anonymous
    9 years ago

    Thanks for your v-yuezhe-msft indications, were the basis for finding the solution.
    The solution is:
    > Install the MySQL Connector / Net 6.6.5 for Microsoft Windows Connector on your computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).
    > After this you must create a user with access permissions to the database, in this case I use phpmyadmin, which is the default manager in xampp

    It is very important that the user on behalf of the server is created as%, so you can access from any client, as shown in the example. If you want to give access only from certain clients, you must enter the corresponding hostname.

    >In Power Bi, make the connection from the Database tab, with the previously created user, password and database access level.

     

    I hope these steps are useful for someone else and I thank all those who contributed me to the solution

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    I've never been able to connect to a MySQL database with domain credentials, only database credentials.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Gracias por una respuesta tan rapida.

      Sigo investigando el tema en el link que muy amablemente indicas. Al realizar la conexion con autenticacion de usuario a nivel de base de datos pasa lo siguiente:

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks for such a quick response.

      I continue investigating the subject in the link that you kindly indicate. When you perform the connection with user authentication at the database level, the following happens:

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Anonymous,

        Firstly, are you able to connect to the database through MySQL workbench? Make sure that MySQL workbench is installed on the same machine with Power BI Desktop. If the connection fails, please follow the guide in this blog to troubleshoot this issue.

        Secondly, if you are able to connect to database using MySQL workbench, please use same connection parameters in Power BI Desktop, and also add port number with server name to connect to MySQL.

        Thirdly, ensure that you install MySQL Connector/Net 6.6.5 for Microsoft Windows on your computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).

        Thanks,
        Lydia Zhang