Cannot see logs in the logdb with MySQL

Question / Problem: 

I have configured MySQL as "logdb" of my Kofax RPA.
When I configured the db setting on the Management Console and click on the "Test" button, I got a successful connection message.
But I got an error stating it is not able to access the log database on the Management Console and I cannot see te logs.

Answer / Solution: 

In case of MySQL, you also need to execute C:\Program Files\Kofax RPA<version>\documentation\sql\logdb\update\mysql-update.sql in addition to the script in C:\Program Files\Kofax RPA<version>\documentation\sql\logdb folder.

Applies to: