MariaDB reader error for MysqlDB with Latin-1 encoding

This sounds familiar to me… I think you are on too old of a version of MySQL Databasae and will need to upgrade for this connection work from FME 2022+.
Likely is related to this issue: https://bugs.mysql.com/bug.php?id=67428

Could you share the version of MySQL DB and the OS Host for the database server?

The only other thing you can do here is to move to a pre-FME 2022 release - FME Desktop 2021.2.6.  You can get that from the Downloads page or use this link https://downloads.safe.com/fme/2021/fme-desktop-2021.2.6-b21821-win-x64.exe.

You might be right about the bug.

Server: MySQL 5.1.41-3

DBeaver does work with the following driver:

MySQL Connector Java [mysql-connector-java-5.1.44 ( Revision: b3cda4f864902ffdde495b9df93937c3e20009be )]

So maybe I could use another driver I was thinking about using an ODBC driver that does work.

@guydaenen I’ve not played with the ODBC and MySQL but it could work. Likely won’t be as performant. 

Hmmm another really long shot is using JDBC Reader (vs MariaDB Reader)…  You could drop the aforementioned driver you tested with DBeaver into /Plugins/Java in our My Documents/FME folder.