Previous page Previous page

Next page Next page

Locate page Locate page

Print this page

Database Servers: database-server.exe

The database-server.exe utility is designed to manage database servers. The utility allows performing the following tasks:

 

Location

%plesk_cli%

 

Usage

database-server.exe <command> [<host[:port]>] [
<option 1> <param> [<option 2> <param>] … [<option N> <param>]
]

 

Example

The following command sets new password newpass for administrator with the login dbadmin on the remote Microsoft SQL database server mssqlserver available at 192.0.2.44.

>database-server.exe --update-server 192.0.2.16:3838 -type mssql -admin dbadmin -reset-passwd newpass

 

Commands

Command

Parameter

Description

Example

--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

 

Options

Option

Parameter

Description

Example

-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