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

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