Previous page

Next page

Locate page

--create-server

<host[:port]>

Adds a database server record to Parallels Plesk Panel.

Requires -type, -admin, -passwd options.

To create the MySQL database server available at 192.0.2.33, with database server administrator's login admin and password setup:

>database-server.exe --create-server 192.0.2.33 -type mysql -admin admin -passwd setup

--update-server

<host[:port]>

Changes configuration settings for the specified database server in Parallels Plesk Panel.

To set password for administrator of a remote MySQL server available at 192.0.2.16:3838 to newdbapass:

>database-server.exe --update-server 192.0.2.16:3838 -reset-passwd newdbapass

--remove-server

<host[:port]>

Removes a database server record from Parallels Plesk Panel.

To remove the MySQL database server available at 192.0.2.33:

>database-server.exe --remove-server 192.0.2.33

--set-default-server

<host[:port]>

Makes a database server primary among servers of the same type, meaning that if in Parallels Plesk Panel a database is created for a domain, it is created on this, default DB server.

To set the MySQL database server available at 192.0.2.33 as default for newly created MySQL databases:

>database-server.exe --set-default-server 192.0.2.33

--set-default-server-local

Assigns a local database server as the default server for the database type.

Requires -type option.

To set the local MySQL server as the default server for MySQL databases:

>database-server.exe --set-default-server-local -type mysql

--help or -h

Displays help on the use of the utility.

>database-server.exe --help

or

>database-server.exe -h

-type

mysql|mssql

Specifies a type of a database server.

Used only with the --create-server.

Required with --create-server.

To create the MySQL database server available at 192.0.2.33, with database server administrator's login admin and password setup:

>database-server.exe --create-server 192.0.2.33 -type mysql -admin admin -passwd setup

-set

<host>|<host>:<port_number>|<port_number>

Specifies a database server host, port number, or a combination of the parameters.

To change the port on which the local MySQL database server listens to from default 3306 to 22222:

>database-server.exe --update-server localhost:3306 -set 22308

-admin

<login_name>

Specifies a database server administrator's login name.

Required with --create-server.

To create the MySQL database server available at 192.0.2.33, with database server administrator's login admin and password setup:

>database-server.exe --create-server 192.0.2.33 -type mysql -admin admin -passwd setup

-passwd

<password>

Specifies database server administrator's password.

Used only with --create-server.

Required with --create-server.

To create MySQL database server available at 192.0.2.33, with database server administrator's login admin and password setup:

>database-server.exe --create-server 192.0.2.33 -type mysql -admin admin -passwd setup

-reset-passwd

<password>

Changes password of the database server administrator.

To change administrator's password to 123456 for the local Microsoft SQL Database server:

>database-server.exe --update-server localhost -type mssql -reset-passwd 123456