MySQL Enterprise Monitor 8.0 Release Notes
On startup, the agent setssql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USERon the monitored MySQL instance. Ifsql_mode=ONLY_FULL_GROUP_BY, agent queries can fail. The local agent of MySQL Enterprise Service Manager also setssql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTIONon the repository.