MySQL instance manager command line option _ MySQL

MySQL instance manager command line options MySQL instance manager supports many command line options. Execute the./mysqlmanager -- help command to list it. The following options are available:

? -- Help ,-?

Displays the help message and exits.

? -- Bind-address = name

The bound address is used for connection.

? -- Default-mysqld-path = name

In Unix, if the instance does not have a path, it is used to find the binary location of the MySQL server. Example: default-mysqld-path =/usr/sbin/mysqld

? -- Defaults-file = file_name

Read the Instance Manager and MySQL server settings from a given file. All Instance Manager configuration changes will be added to this file. It can only be used in the first option of Instance Manager.

? -- Install

In Windows, install Instance Manager as a Windows service.

? -- Log = name

The path of the IM log file. Use it with the -- run-as-service option.

? -- Monitoring-interval = Seconds

Monitoring instance interval, in seconds. Instance Manager will try to connect to each monitored Instance to check whether they are active/not suspended. If a fault occurs, the IM will restart the instance several times (in fact multiple times. You can use the nonguarded option to disable this behavior for a specific instance. If no value is specified, the default value is 20 seconds.

? -- Passwd,-P

Write the passwd file and exit.

? -- Password-file = name

Find the Instance Manager user and password from the file. The default file is/etc/mysqlmanager. passwd.

? -- Pid-file = name

Process ID file used. By default, the file name is mysqlmanager. pid.

? -- Port = port_num

The port number used for connection. (The default port number allocated by IANA is 2273 ).

? -- Print-defaults

Print the current default value and exit. It can only be used as the first option for Instance Manager.

? -- Remove

Delete the Instance Manager Windows service in Windows. Assume that the Instance Manager has been run with -- install.

? -- Run-as-service

Change the process to a background program and start it. The process of improvement is simple and not easy to crash. After a fault occurs, it restarts IM itself.

? -- Socket = name

The socket file used for connection in Unix. By default, the file name is/tmp/MySQLmanager. sock.

? -- Standalone

Run Instance Manager in standalone mode in Windows.

? -- User = name

Username for starting and running mysqlmanager. We recommend that you use the user account that runs the mysqld server to run mysqlmanager.

? -- Version,-V

Output the version information and exit.