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 --update_instance

 

Site24x7 stores only one credential for monitoring per MySQL instance. So, we would update the existing credentials based on hostname and port.

 

Related article:

It says, "Failed to register MySQL instance." How to troubleshoot?

• 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 ...

• 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 ...

• How does Site24x7 always ensure the availability of its location agents during monitoring?

  Site24x7 uses a preferred location recheck logic in the back-end to ensure the availability of all monitoring locations. This logic is only applied when you've disabled the option "Restrict monitoring within selected locations" in the Add or Edit ...

• Exclude the selective SSH algorithms in On-Premise Poller during SFTP Transfer monitoring

  By excluding SSH algorithms, you can restrict Site24x7 SSH Client from using the excluded algorithm while connecting to the SSH server during SFTP Transfer monitoring. Follow the steps mentioned below for SSH algorithm exclusion in On-Premise Poller ...