Why is my MySQL monitor not discovered?

Why is my MySQL monitor not discovered?

If your MySQL is not getting discovered, you cannot add your MySQL, you are unable to add MySQL server for monitoring, or unable to view your MySQL resources, try discovering your resources by navigating to Server > Server Monitor > Rediscover Applications.

Your MySQL monitor may not be discovered if:

1. You use an older agent version.

  • Check if the Site24x7 server monitoring agent version is 19.0.0 or above by using the following command:

    cat /opt/site24x7/monagent/version.txt

    If the agent version is below 19.0.0,  please upgrade the agent.

  • If the agent version is above 19.0.0, check if the Linux agent is promptly running by using the below command:

    sudo /opt/site24x7/monagent/bin/monagent status

  • If the agent is down, start the agent by using the command:

    sudo /opt/site24x7/monagent/bin/monagent start

2. The credentials you provide are incorrect. Please check the MySQL user credentials and grant the necessary permissions. To add or update the credential, check this article. 

3. You have exhausted your licenses. Find the licensing details of MySQL monitor here. 

    • Related Articles

    • I can only see a limited amount of MySQL database monitors added. How to add new databases for monitoring?

      By default, MySQL instances will be auto-discovered and added as free monitors. MySQL data collection and monitoring will start once the agent is provided with the proper credentials. Check this article on how to add or update credentials. New ...

    • How is MySQL added for monitoring in Site24x7?

      Site24x7 uses the server monitoring agent to monitor MySQL databases. To install the Site24x7 Server monitoring agent, follow the below steps: Log in to Site24x7. Install the Linux Server monitoring agent by navigating to Server > Server Monitor > ...

    • MySQL monitoring FAQs

      Please find below some common FAQ's related to MySQL monitoring from Site24x7: Does Site24x7 need write permission to access databases? No. Site24x7 needs SELECT permission for performance_schema, information_schema, and EXECUTE permission for sys ...

    • How to add/update the credentials of my MySQL database?

      To add the credentials, execute the below command: sudo /opt/site24x7/monagent/scripts/AgentManager.sh mysql --add_instance To update the credentials, execute the below command: sudo /opt/site24x7/monagent/scripts/AgentManager.sh mysql ...

    • My MySQL monitor shows "no data."

      Troubleshooting tips when no data is shown in MySQL monitor: Please provide the credentials to the Site24x7 server monitoring agent using the following command: sudo /opt/site24x7/monagent/scripts/AgentManager.sh mysql --add_instance Ensure the ...