How should I configure MySQL DB monitor?
Q: How to configure MySQL DB monitor?
A: IPNetwork Monitor doesn’t require explicit downloading and installing MySQL client DLL.
In the monitor’s “Main Parameters” tab
- specify SQL request that returns an integer value
- specify database name
- enter TCP port value if different from MySQL default, 3306
- check “Use SSL Connection” and specify a certificate file if you prefer to use SSL connection
- specify Unix-like credentials to connect to the specified MySQL database
Related topics
Check out our Knowledge Base where we answer questions regarding various topics. Use a SQL request that returns an integer value, because the monitor uses that returned value as the measured result. No. Current IPNetwork Monitor builds do not require explicitly downloading and installing a MySQL client DLL for the MySQL DB monitor. Enter the database name, port, SSL certificate choice, and Unix-like database credentials on the monitor Main Parameters tab.
Frequently Asked Questions
What should the SQL query for a MySQL DB monitor return?
Is a separate MySQL client DLL installation required?
Where are MySQL connection settings entered?