utility allows you to manage Plesk-controlled databases and database users. Using this utility, you can:Database.exe
is located in Database.exe %plesk_dir%admin\bin\. Available commands and options are listed in tables below.
Usage: database.exe command <db_name> [options]
Example of usage:
database.exe --create John_Doe_DB -domain domain1.com -type mysql -passwd "MyPass"
Available commands:
Command |
Parameter |
Action |
Examples |
|
<db_name> |
creates a database |
To create John_Doe_DB database on somewhere.com domain:
|
|
<db_name> |
updates a database: adds, edits, removes a db user |
Examples of updating various domain parameters are provided further down the table |
|
<db_name> |
deletes a database |
To remove John_Doe_DB from somewhere.com domain:
|
|
|
displays help on the utility usage |
To see help file on the utility usage:
|
Available options:
Option |
Parameter |
Note |
Examples |
|
<domain_name> |
domain name (required for creation) |
To create John_Doe_DB database on Somewhere.com domain:
|
|
<mssql|mysql>
|
type of a database |
To specify type of John_Doe_DB as MySQL database:
|
|
<passwd> |
sets user password |
To set John Doe's password for accessing John-Doe-DB database:
|
|
<login_name> |
adds the user with the specified name |
To add Jim_Doe user to the list of John_Doe_DB database users:
|
|
<login_name> |
updates the user with the specified name |
To update user John_Doe:
|
|
<login_name> |
removes the user with the specified name |
To remove John_Doe user:
|
|
<login_name> |
sets login name (may be set/specified with the ' |
To set login name as JD for John_Doe user of John_Doe_DB database:
|