Unanswered

Test Connection Failed when trying to connect to MySQL

(0) Share

Report

Posted on by Jolinsiow

Hi Team,

I am currently facing issues in connecting to MySQL connector on Power Automate web. This is the error that I am getting "Test connection failed. Details: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. inner exception: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. clientRequestId: "

Could the creation of a new gateway and thereafter the connection be hindered by my organisation's firewall? or there are other reasons. Hope to seek you assistance.

I have installed the following prerequites:

On-Premises data gateway
MySQL Connector NET
MySQL version 5.1.12
MySQL Workbench 8.0

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (0)

Sort by

lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Which version of MySQL Connector NET?

Was this reply helpful? Yes No
Jolinsiow 6 on at

Like
a
(0)

Report
Copy link

Link copied!

I installed MySQL Connector NET 8.0.28

Was this reply helpful? Yes No
lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

That's good. You installed it on all gateway cluster members? Can you validate the connectivity via Workbench?

Was this reply helpful? Yes No
Jolinsiow 6 on at

Like
a
(0)

Report
Copy link

Link copied!

I did not install it on gateway cluster members because when I clicked on the dropdown that is supposed to provide options of cluster members to select, mine was blank.

Was this reply helpful? Yes No
lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Please redo that part. A gateway is mandatory for on-premise data sources.

Was this reply helpful? Yes No