Each front-end and Timer server in your farm will need to have the "ADO.NET Driver for MySQL" installed on it, whether by running MySQL Connector exe or by simply registering DLL files.

Our product was built with MySql.Data.dll version 6.7.9.0 in order to support SharePoint 2010. This connector version is a bit older, but it is the latest one that still support Microsoft .net Framework 3.5, which is used by SharePoint 2010.

If you prefer using a newer version of the above DLL, you will need to modify the following config files to have an assembly binding to your newer Connector version:

1. web.config of your SharePoint web site (on every WFE server)
2. owstimer.exe.config, which will be used by the SharePoint Timer service (on every farm server that runs the Timer service). If this file does not exist, create it.

The full content of the config file will be as the following, beware that in most cases only the parted highlighted in blue will have to be merged into your local configuration file:

<configuration>

  <runtime>

    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

      <dependentAssembly xmlns="urn:schemas-microsoft-com:asm.v1">

        <assemblyIdentity name="MySql.Data" publicKeyToken="c5687fc88969c44d" culture="neutral" />

        <bindingRedirect oldVersion="6.7.9.0" newVersion="8.0.11.0" />

      </dependentAssembly>

    </assemblyBinding>

  </runtime>

</configuration>

8.0.11.0 - the version number will need to be adjusted to the version of the dll file you have on your server.

NOTE: when editing the web.config file, these elements already exist, so just locate the path: configuration/runtime/assemblyBinding and add the dependentAssembly element into it.

After this modification is done, restart the SharePoint Timer services and perform an IISRESET.