Create Read Only MySQL Users
Though the standard configuration includes a read-only ewreader MySQL user, it is only allowed to connect to the database from localhost and is re-created during installations and updates with a different password. As such it is not usable for external report engine connectivity.
If the database is recreated during upgrade this user will be lost and will have to be re-created.
This however only happens when the version of MySQL is upgraded and if the upgrade requires data to be recreated.
If in doubt, verify that external connectivity is retained after upgrade.
Follow These Steps
From the Agiloft host log into embedded MySQL instance as administrative level user:
Create a new user and grant appropriate read permissions:
Verify connectivity with the new user by logging into MySQL again: