Qlik Replicate: Failed to parse the incoming connect string MySQL

[Alan_Wang]

The following error is shown when testing a MySQL connection:

SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: HY000 NativeError: 0 Message: [MySQL][ODBC 8.0(w) Driver]Failed to parse the incoming connect string.

The error refers to the password of the user used in the MySQL connection and indicates characters in your password which cannot be parsed. A password change to avoid special characters is recommended.

Resolution

Change the MySQL user password to exclude special characters you may have in the password.

Internal Investigation ID(s)

Case 00078264

Environment

Qlik Replicate 
MySQL source endpoint