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

    • How do I monitor an Oracle database hosted in a Docker container in the same machine?

      To monitor your Oracle Database hosted in a Docker container, follow these steps: Log in to Site24x7 and install the Site24x7 Linux monitoring agent. Execute the following command in your terminal and enter your Oracle Database instance's username ...

    • Troubleshoot connection errors in the MySQL plugin

      When configuring the MySQL plugin, you may encounter the following errors: Error : Connection Error - This error typically indicates that there is a problem establishing a connection to the database. Sometimes, this message is supplemented with an ...

    • Unable to add SQL insight monitor

      If the SQL Insight monitor is not getting added even after entering your credentials, try these troubleshooting steps: Ensure that the Auto-discover applications feature is enabled. If not, you will need to trigger discovery using the Discover ...

    • Troubleshoot the "pymysql module not found" error when installing the MySQL plugin

      If you're encountering the pymysql module not found error, it likely means that the pymysql Python library is not installed on the server. pymysql is a Python package that provides a way to interact with MySQL databases using Python code and is used ...

    • Troubleshooting false positive alerts in monitoring

      Problem False positive alerts are being generated. Possible cause The monitoring system is down in some locations. The Website monitor might be configured for one location, such as Seattle, but may appear down when accessed from another location, ...