How to insert data into mysql using sharepoint 2019

See more:

MySQL

SharePoint

Hi,

Using : Sharepoint visual web part, c#

Requirement : need to save data into MySQL using Sharepoint 2019 (CRUD operations)

i have 1 vm for Sharepoint 2019 where everything is installed like Sharepoint 2019 ,sql server 2016, window server 2019 & visual studio 2019.

I have successfully inserted data into MySQL using ado.net ( add DLL of MySQL.client.data )

Problem : I have farm ( 3 vim , 1 wife, 1 app & 1 sql server db ) , as I take .wsp from my dev to app server to install wsp ( add solution ) , MySQL does not work like mysqlcommand, MySQL connection,MySQL parameter nothing work.

Solution looking for :

as same code is working fine on single machine but not on 3 machines ( farm ,wife,app and db )

what to do to get it done..

note : I am using store procedure , and calling these procedures function using Ajax call.,

sql connection and command are working fine but not MySQL only on farm

thanks

What I have tried:

Install visual studio on app & WFE server
Install Mysql Client