Error 1040 (Too many connections) connecting to MySQL server

[OritA]

When running a Replicate task with MySQL source endpoint and getting the following error in the task log: 

[SOURCE_CAPTURE ]E: Error 1040 (Too many connections) connecting to MySQL server ‘xxx.yyy.zzz'

Cause 

This error can be caused due to unsupported version of MySQL ODBC driver 

Environment

• Replicate with MySQL source endpoint

Resolution

For every Replicate version, the supported ODBC driver versions are listed in the Replicate Users Guide under: 

Adding and managing source endpoints --> Using a MySQL-based database as a source --> Prerequisites  --> Client prerequisites

For example the ODBC driver version supported in Replicate 2021 November release are: 

MySQL ODBC 64-bit client 5.3.11 or above. However,  Drivers 8.0 to 8.0.22 are not supported.