To add a MySQL server for monitoring:
Note: If the name of the MySQL server is manually entered, the port number has to be filled. For the MySQL servers selected from the list of discovered servers, the port number will be filled in automatically.
To make changes to the time zone and file encoding, click on the Advanced button and choose the relevant option from the drop downs provided.
The MySQL server configuration file is found using the mysqld process.
The MySQL server configuration file is found using the mysqld.exe process.
In addition, the configuration file parameters are explored in the order:
If the MySQL configuration file is not found with the mysqld or mysqld.exe process, then the following occurs:
UNIX or Linux: The configuration file location defaults to the location
Windows: The configuration file location defaults to the following locations
From the command line parameters and the configuration file, the MySQL server General log path and Error log path are discovered.
For Windows devices, credentials for discovery is picked in the following order:
For Linux devices, the credentials used while configuring auto log forward will be used for MySQL discovery.
Note: In Linux installations, MySQL server discovery on Windows devices is not possible.