Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Power Automate connect mysql

(0) ShareShare
ReportReport
Posted on by 2

Hey guys,

 

I want to use mysql connector to connect my local mysql database, but it shows : unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. I had install the mysql connector with link: https://dev.mysql.com/downloads/connector/net/

 

anyone give me any idea? thanks!

  • Dario87 Profile Picture
    Dario87 7 on at
    Re: Power Automate connect mysql

    8.0.28 is the right version. After a reboot it started working properly. Thanks!!

  • lbendlin Profile Picture
    lbendlin 7,597 on at
    Re: Power Automate connect mysql

    You are not using 8.0.28.  Can't help you unless you use 8.0.28

  • Dario87 Profile Picture
    Dario87 7 on at
    Re: Power Automate connect mysql

    I've checked and it's installed.

    Screenshot 2023-09-14 at 18.13.19.png

     

    Nevertheless I'm facing the same issue:

    Screenshot 2023-09-14 at 18.15.29.png

     

    I'm using Azure Logic Apps.

    No issues on Azure Data Factory. The connection is established and I can read data without problem, but I need to write on a particular table and only Logic Apps have the right connector

  • lbendlin Profile Picture
    lbendlin 7,597 on at
    Re: Power Automate connect mysql

    Use RDP to log into the gateway machine, and check if the drivers are installed

     

    lbendlin_0-1694705721076.png

     

  • Dario87 Profile Picture
    Dario87 7 on at
    Re: Power Automate connect mysql

    @lbendlin what do you mean with "The gateway needs to have the MySQL driver installed"?

    How to check the drivers installed in the on-prem data gateway?

  • lbendlin Profile Picture
    lbendlin 7,597 on at
    Re: Power Automate connect mysql

    You need to use a gateway. The gateway needs to have the MySQL driver installed.  My recommendation is to use 8.0.28 - all the newer ones have massive problems.

  • AmyS7 Profile Picture
    AmyS7 2 on at
    Re: Power Automate connect mysql

    service😀

  • lbendlin Profile Picture
    lbendlin 7,597 on at
    Re: Power Automate connect mysql

    Power Automate Desktop or service?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics