What are the minimum grants a mysql user must have to successfully execute the agent script? I’m not keen to the idea that I should use the root db user in the mysql script settings.
Check what commands the script runs. Likely you don’t need any or many permissions granted to the user. Docs are gear towards the defaults for beginners.