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

• 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 to configure the NGINX status page for monitoring NGINX performance

  The NGINX plugin uses the NGINX status page to pull the performance metrics of the NGINX server. You may encounter the following errors while installing the NGINX plugin integration: Error_code : HTTP Error 404: This error usually indicates that the ...

• Site24x7 Real User Monitoring (RUM) - Data Collection

  When you include Site24x7 RUM beacon script in your web pages, the following data is collected. All data that's being collected is in accordance with GDPR compliance. Performance details of web page load time - Metrics like response time of web page ...

• Validating sender email using DKIM authentication

  What is DKIM? DomainKeys Identified Mail (DKIM) is an advanced authentication method used widely by email service providers to verify the email from the point of its origin by validating the email sender. It allows the email senders to authenticate ...

• Troubleshoot the Unauthorized user (Error 401) when installing Tomcat plugins

  When installing Tomcat plugins, you may encounter the following error: Unauthorized user. Does not have permissions. HTTP Error 401: This error usually occurs when the user accessing the Tomcat Manager application does not have the necessary ...