MySQL Database Connection Error with Power Apps

[Syndicate_Admin]

I was trying to connect a MySQL database with Power Apps and encountered the following error:

'MySql.Data.MySqlClient'. inner exception: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. clientRequestId: 968e3361-0261-44bc-9556-0496f2bfcdd3."

I installed different versions of the connector and server, but I still can't solve it.