MySQL Enterprise Monitor 8.0.22 Manual

10.1 Service Manager Configuration Utilities


The parameters listed here, with the exception of the four repository connection parameters, correspond to those displayed on the Welcome to MySQL Enterprise Monitor page used for initial setup. For more information, see Section 13.1, “Initial Log-In”.


These parameters enable you to configure MySQL Enterprise Service Manager from script or command line and should only be run while the MySQL Enterprise Service Manager is stopped.

The / config.bat script is used to configure the MySQL Server Repository for the Service Monitor. Its default location is as follows:

Table 10.1 Default Location of Agent Configuration Utility

Operating System File Location

Microsoft Windows

C:\Program Files\MySQL\Enterprise\Monitor\bin\config.bat



Mac OS X


Use --help to view the options.

The Service Manager configuration utility contains the following sets of commands:

Service Manager Configuration Utilities

The config script enables you to define or change any of the system configuration parameters such as credentials used to connect to the repository, proxy connection details, and MySQL Enterprise Service Manager user credentials.

Table 10.2 Service Manager Configuration Utilities

Name Description



MySQL username for the Service Manager repository. The password is requested via STDIN when the command is run. The default value is service_manager.



MySQL port for the Service Manager repository. The port the target MySQL server listens on. The default is 13306.



MySQL database for the Service Manager repository. The name of the database used for the repository. The default is mem.



MySQL server for the Service Manager repository. This must be a resolvable name or IP address of the server where the MySQL instance is running.


Checks your repository to ensure compatibility with MySQL Enterprise Service Manager. For more information on the checks performed, see Section 3.2.4, “MySQL Enterprise Monitor Repository”.


Runs mysql_upgrade on the repository defined in --mysql-basedir.


Base directory of the local MySQL installation.


Service Manager manager username. The user defined here is added to the manager role.


Service Manager agent username. The user defined here is added to the agent role.


Enable automatic checking for online updates.


Defines the Query Analyzer data retention policy. Query Analyzer data older than the number of days defined here is deleted. Default is 28 days.


Defines the historical data retention policy. Historical data older than the number of days defined here is deleted. Default is 28 days.


HTTP Proxy host.


HTTP Proxy port.


HTTP Proxy username.


Passwords are always requested via STDIN and are requested in the order manager, agent, and proxy, regardless of the order in which they are defined on the command line or in script.

The following example instructs MySQL Enterprise Service Manager to use a locally installed instance, listening on port 3306, the mem database, and connect using the user service_manager.: --mysql-server=localhost --mysql-port=3306 --mysql-db=mem 

The following is an example of a basic setup, defining the admin and agent users, only. : --sm-admin-user=admin --sm-agent-user=agent

All other parameters are set to their default values.


You are prompted to define passwords for each of the users defined. Passwords are only accepted through STDIN.

Passwords are always requested in the order manager, agent, proxy, regardless of the order defined on the command line or in the script.

All other values are set to their defaults.

The following is an example of a complete setup, defining all available options: --sm-admin-user=admin --sm-agent-user=agent --purge-quan=7 
          --purge-data=14 --proxy-host=localhost --proxy-port=9190 
          --proxy-user=proxy --auto-update

Service Manager Certificate Utilities

The certificate utilities enable you to modify, renew, import, and upgrade your SSL certificates.


It is strongly recommended you use this utility to modify your SSL certificates and not attempt to modify them with any other tool.

Table 10.3 Service Manager Certificate Utilities

Name Description



Tomcat backup path to be used to perform upgrade



Upgrades certificates on non-OS X platforms. That is, Microsoft Windows, Linux, and so on.



Upgrades certificates on OS X platforms.



Generates a keystore with a new self-signed certificate for a new installation



If specified, the user is prompted to enter the keystore password. If not specified, the default password changeit is used to access the keystore.


Renew an existing, self-signed certificate. If the certificate is not self-signed, an error is returned.


Imports the specified certificate. For example:



Imports the specified private key. For example: