To enable the power user:
++++++++++++++++++++++++++++
In order to enable the Power User view, run the command:
C:\> "%plesk_cli%\poweruser.exe" --on
To switch the Power User view off and return to the standard panel, use this command:
C:\> "%plesk_cli%\poweruser.exe" --off
panel:- Tools & settings -->Interface Management --> Power User view or Service Provider view
++++++++++++++++++++++++++++
Directory Structure
+++++++++++++++++++++++++++++
Parallels Plesk Panel and its components are installed by default in the directory C:\Program
Files\Parallels\Plesk\ on a physical server, or C:\Program Files\Plesk\ in the
Parallels Containers environment. The default directory is referred to as %plesk_dir% in the
following list. Some of the subdirectories with corresponding components are listed below.
• %plesk_dir%\admin\ - Parallels Plesk Panel service administrator (psa) files
• %plesk_dir%\admin\plib\ - Parallels Plesk Panel PHP files
• %plesk_dir%\admin\bin\ - Binary utilities
• %plesk_dir%\bin\ - Binary utilities
• %plesk_dir%\admin\htdocs\ - Administrative site document root
• %plesk_dir%\etc\ - Configuration files
• %plesk_dir%\MailServer\ - Mail servers
• %plesk_dir%\backup\ - Domain backup files
• %plesk_dir%\dns\ - BIND name server files
• %plesk_dir%\MySql\ - admin MySQL database server
• %plesk_dir%\Databases\ -
• %plesk_dir%\admin\repository\keys\ - License key files
• %plesk_dir%\admin\logs - Log files.
++++++++++++++++++++++++++++++
Windows Registry
+++++++++++++++++++++++++++++
The Parallels Plesk Panel branch in the Registry is
• HKEY_LOCAL_MACHINE\SOFTWARE\PLESK for 32-bit system and
• HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PLESK for 64-bit system.
The configuration is located under \PLESK\PSA Config\Config
These are important registry parameters:
• IIsConfigured - REG_DWORD = 1
• mySQLDBName - REG_SZ = psa
• PLESK_DATABASE_LOGIN - REG_SZ = admin
• PLESK_DATABASE_PROVIDER_NAME - REG_SZ = may be MySQL, or MSSQL
• PLESKCP_PROVIDER_NAME - REG_SZ = iis
• PRODUCT_FULLVERSION - REG_SZ
• DEBUG - REG_DWORD = 0 or 1
++++++++++++++++++++++++++++++
Parallels Plesk Panel - Supported Databases
++++++++++++++++++++++++++++++
--- MySQL
--- Microsoft SQL
To determine database provider, you need to run regedit.exe and go to:
• HKEY_LOCAL_MACHINE\SOFTWARE\PLESK\PSA Config\Config for 32-bit system
• HKEY_LOCAL_MACHINE\SOFTWARE\wow6432node\PLESK\PSA Config\Config for
64-bit system
The value of the key "PLESK_DATABASE_PROVIDER_NAME" is the database provider which
the Panel uses for database storage.
+++++++++++++++++++++++++++++++++
MySQL Database
+++++++++++++++++++++++++++++++++
Parallels Plesk Panel uses the following locations to administer the MySQL database:
• "%plesk_dir%"\MySQL admin MySQL instance main folder.
• "%plesk_dir%"\MySQL\Data\my.ini admin MySQL configuration file.
The following command can be used to log in into the MySQL console:
C:\>"%plesk_dir%"\MySQL\bin\mysql.exe -uadmin -p<password> -P8306 psa
Useful parameters of the my.ini configuration file are:
• skip-grant-tables - log in without password.
• log=C:\\Temp\\mysql.log - enable MySQL log (you can specify another file name and
path.)
++++++++++++++++++++++++++++++++
my.ini
+++++++++++++++++++++++++++++++
C:\Program Files (x86)\Parallels\Plesk\MySQL\Data>type my.ini
[PleskSQLServer]
port=8306
basedir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL
datadir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
default-character-set=latin1
default-storage-engine=INNODB
query_cache_size=8M
table_cache=32
tmp_table_size=7M
thread_cache=32
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=300
key_buffer=4M
max_allowed_packet=1M
sort_buffer=256K
net_buffer_length=4K
old_passwords=0
tmpdir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
connect_timeout=20
[client]
port=8306
+++++++++++++++++++++++++++++++++++++
MS SQL Database
+++++++++++++++++++++++++++++++++++++
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql –E
The osql utility allows you to enter Transact-SQL statements, system procedures, and script
files. This utility uses ODBC to communicate with the server.
To change the MSSQL administrator's password, start the command prompt session.
• For local server use:
C:\>osql -E -Q "exec sp_password NULL,'new_password','sa'"
• For remote server use:
C:\>osql -S servername_or_address -E -Q "exec sp_password NULL,'new_password','sa'"
Managing Databases
+++++++++++++++++++++++++++++++++++++++
%plesk_cli% contains database-server.exe and database.exe
For example, in order to create the MySQL database server available at 10.0.20.30, with the
database server administrator's login admin and password password, enter:
C:\>database-server.exe --create-server 10.0.20.30 -type mysql -admin admin -passwd password
In order to set a new password password for the database server administrator with login
admin on the remote Microsoft SQL database server mssqlserver available at 10.0.20.40:3838,
enter:
C:\>database-server.exe --update-server 10.0.20.40:3838 -type mssql -admin admin -reset-passwd password
++++++++++++++++++++++++++++++++++++++
create a MySQL database on the domain.tst
++++++++++++++++++++++++++++++++++++++
For example, to create a MySQL database on the domain.tst domain, enter:
C:\>database.exe --create jsmithdb -domain domain.tst -type mysql
To assign the setup password for the database user jsmithdb with the login name of
JohnSmith, enter:
C:\>database.exe --update jsmithdb -update_user JohnSmith -passwd setup
+++++++++++++++++++++++++++++++++++++
Cannot Configure Client MySQL Server in Parallels Plesk Panel
++++++++++++++++++++++++++++++++++++
Failed to connect to database: Access denied for user admin@localhost
Diagnostics
• This problem occurs when Parallels Plesk Panel's connection to the MySQL server that
houses its user databases is incorrectly configured.
To configure the settings, follow the next steps.
1. Edit the MySQL configuration file my.ini located within %plesk_dir%\mysql\data.
Add parameter skip-grant-tables into the [PleskSQLServer] section.
2. Restart SQL Server.
3. Log into MySQL.
4. Type the following command.
1. Edit the MySQL configuration file my.ini located within %plesk_dir%\mysql\data.
Add parameter skip-grant-tables into the [PleskSQLServer] section.
2. Restart SQL Server.
3. Log into MySQL.
4. Type the following command.
mysql> update user set password=password('admin_password') where
user='admin';
5. Remove skip-grant-tables from within the [PleskSQLServer] section from
%plesk_dir%\mysql\data\my.ini.
6. Restart MySQL Server.
++++++++++++++++++++++++++++++++++++++
Passwords Synchronization
When trying to log in to Parallels Plesk Panel, you get an error message.
This happens if the password for admin in Parallels Plesk Panel does not match the one set in MySQL
First, you need to retrieve your current Parallels Plesk Panel password:
C:\>"%plesk_dir%\admin\bin\plesksrvclient.exe" -get
Then, you should set it up within MySQL. To do this, follow these steps:
+++++++++++++++++++++++++++++++++++++++++
How to get the plesk verion:
%plesk_dir%--> Type version
++++++++++++++++++++++++++++++++++++++
Initial Plesk Panel Installation
++++++++++++++++++++++++++++++++++++++
There are several ways to install Parallels Plesk Panel:
• Use the Web Interface
• Use the Command Line Interface
• Use the Parallels Containers VZ Template to install the product in a container
• Downloaded packages
• The *.inf3 files
• The log file is autoinstaller3.log
• The error log file is %plesk_dir%\admin\logs\php_error.log.
The repository URL is located at: http://autoinstall-win.pp.parallels.com
If you want to specify any custom locations such as the vhosts location for the Parallels Plesk
Panel, before the installation add into the \PLESK\PSA Config\Config registry key the
following string values:
• PRODUCT_ROOT_D - panel installation path
• PRODUCT_DATA_D - panel data storage path
• HTTPD_VHOSTS_D - vhosts path
++++++++++++++++++++++++++++
In order to enable the Power User view, run the command:
C:\> "%plesk_cli%\poweruser.exe" --on
To switch the Power User view off and return to the standard panel, use this command:
C:\> "%plesk_cli%\poweruser.exe" --off
panel:- Tools & settings -->Interface Management --> Power User view or Service Provider view
++++++++++++++++++++++++++++
Directory Structure
+++++++++++++++++++++++++++++
Parallels Plesk Panel and its components are installed by default in the directory C:\Program
Files\Parallels\Plesk\ on a physical server, or C:\Program Files\Plesk\ in the
Parallels Containers environment. The default directory is referred to as %plesk_dir% in the
following list. Some of the subdirectories with corresponding components are listed below.
• %plesk_dir%\admin\ - Parallels Plesk Panel service administrator (psa) files
• %plesk_dir%\admin\plib\ - Parallels Plesk Panel PHP files
• %plesk_dir%\admin\bin\ - Binary utilities
• %plesk_dir%\bin\ - Binary utilities
• %plesk_dir%\admin\htdocs\ - Administrative site document root
• %plesk_dir%\etc\ - Configuration files
• %plesk_dir%\MailServer\ - Mail servers
• %plesk_dir%\backup\ - Domain backup files
• %plesk_dir%\dns\ - BIND name server files
• %plesk_dir%\MySql\ - admin MySQL database server
• %plesk_dir%\Databases\ -
• %plesk_dir%\admin\repository\keys\ - License key files
• %plesk_dir%\admin\logs - Log files.
++++++++++++++++++++++++++++++
Windows Registry
+++++++++++++++++++++++++++++
The Parallels Plesk Panel branch in the Registry is
• HKEY_LOCAL_MACHINE\SOFTWARE\PLESK for 32-bit system and
• HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PLESK for 64-bit system.
The configuration is located under \PLESK\PSA Config\Config
These are important registry parameters:
• IIsConfigured - REG_DWORD = 1
• mySQLDBName - REG_SZ = psa
• PLESK_DATABASE_LOGIN - REG_SZ = admin
• PLESK_DATABASE_PROVIDER_NAME - REG_SZ = may be MySQL, or MSSQL
• PLESKCP_PROVIDER_NAME - REG_SZ = iis
• PRODUCT_FULLVERSION - REG_SZ
• DEBUG - REG_DWORD = 0 or 1
++++++++++++++++++++++++++++++
Parallels Plesk Panel - Supported Databases
++++++++++++++++++++++++++++++
--- MySQL
--- Microsoft SQL
To determine database provider, you need to run regedit.exe and go to:
• HKEY_LOCAL_MACHINE\SOFTWARE\PLESK\PSA Config\Config for 32-bit system
• HKEY_LOCAL_MACHINE\SOFTWARE\wow6432node\PLESK\PSA Config\Config for
64-bit system
The value of the key "PLESK_DATABASE_PROVIDER_NAME" is the database provider which
the Panel uses for database storage.
+++++++++++++++++++++++++++++++++
MySQL Database
+++++++++++++++++++++++++++++++++
Parallels Plesk Panel uses the following locations to administer the MySQL database:
• "%plesk_dir%"\MySQL admin MySQL instance main folder.
• "%plesk_dir%"\MySQL\Data\my.ini admin MySQL configuration file.
The following command can be used to log in into the MySQL console:
C:\>"%plesk_dir%"\MySQL\bin\mysql.exe -uadmin -p<password> -P8306 psa
Useful parameters of the my.ini configuration file are:
• skip-grant-tables - log in without password.
• log=C:\\Temp\\mysql.log - enable MySQL log (you can specify another file name and
path.)
++++++++++++++++++++++++++++++++
my.ini
+++++++++++++++++++++++++++++++
C:\Program Files (x86)\Parallels\Plesk\MySQL\Data>type my.ini
[PleskSQLServer]
port=8306
basedir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL
datadir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
default-character-set=latin1
default-storage-engine=INNODB
query_cache_size=8M
table_cache=32
tmp_table_size=7M
thread_cache=32
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=300
key_buffer=4M
max_allowed_packet=1M
sort_buffer=256K
net_buffer_length=4K
old_passwords=0
tmpdir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
connect_timeout=20
[client]
port=8306
+++++++++++++++++++++++++++++++++++++
MS SQL Database
+++++++++++++++++++++++++++++++++++++
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql –E
The osql utility allows you to enter Transact-SQL statements, system procedures, and script
files. This utility uses ODBC to communicate with the server.
To change the MSSQL administrator's password, start the command prompt session.
• For local server use:
C:\>osql -E -Q "exec sp_password NULL,'new_password','sa'"
• For remote server use:
C:\>osql -S servername_or_address -E -Q "exec sp_password NULL,'new_password','sa'"
Managing Databases
+++++++++++++++++++++++++++++++++++++++
%plesk_cli% contains database-server.exe and database.exe
For example, in order to create the MySQL database server available at 10.0.20.30, with the
database server administrator's login admin and password password, enter:
C:\>database-server.exe --create-server 10.0.20.30 -type mysql -admin admin -passwd password
In order to set a new password password for the database server administrator with login
admin on the remote Microsoft SQL database server mssqlserver available at 10.0.20.40:3838,
enter:
C:\>database-server.exe --update-server 10.0.20.40:3838 -type mssql -admin admin -reset-passwd password
++++++++++++++++++++++++++++++++++++++
create a MySQL database on the domain.tst
++++++++++++++++++++++++++++++++++++++
For example, to create a MySQL database on the domain.tst domain, enter:
C:\>database.exe --create jsmithdb -domain domain.tst -type mysql
To assign the setup password for the database user jsmithdb with the login name of
JohnSmith, enter:
C:\>database.exe --update jsmithdb -update_user JohnSmith -passwd setup
+++++++++++++++++++++++++++++++++++++
Cannot Configure Client MySQL Server in Parallels Plesk Panel
++++++++++++++++++++++++++++++++++++
Failed to connect to database: Access denied for user admin@localhost
Diagnostics
• This problem occurs when Parallels Plesk Panel's connection to the MySQL server that
houses its user databases is incorrectly configured.
To configure the settings, follow the next steps.
1. Edit the MySQL configuration file my.ini located within %plesk_dir%\mysql\data.
Add parameter skip-grant-tables into the [PleskSQLServer] section.
2. Restart SQL Server.
3. Log into MySQL.
4. Type the following command.
1. Edit the MySQL configuration file my.ini located within %plesk_dir%\mysql\data.
Add parameter skip-grant-tables into the [PleskSQLServer] section.
2. Restart SQL Server.
3. Log into MySQL.
4. Type the following command.
mysql> update user set password=password('admin_password') where
user='admin';
5. Remove skip-grant-tables from within the [PleskSQLServer] section from
%plesk_dir%\mysql\data\my.ini.
6. Restart MySQL Server.
++++++++++++++++++++++++++++++++++++++
Passwords Synchronization
When trying to log in to Parallels Plesk Panel, you get an error message.
This happens if the password for admin in Parallels Plesk Panel does not match the one set in MySQL
First, you need to retrieve your current Parallels Plesk Panel password:
C:\>"%plesk_dir%\admin\bin\plesksrvclient.exe" -get
Then, you should set it up within MySQL. To do this, follow these steps:
+++++++++++++++++++++++++++++++++++++++++
How to get the plesk verion:
%plesk_dir%--> Type version
++++++++++++++++++++++++++++++++++++++
Initial Plesk Panel Installation
++++++++++++++++++++++++++++++++++++++
There are several ways to install Parallels Plesk Panel:
• Use the Web Interface
• Use the Command Line Interface
• Use the Parallels Containers VZ Template to install the product in a container
• Downloaded packages
• The *.inf3 files
• The log file is autoinstaller3.log
• The error log file is %plesk_dir%\admin\logs\php_error.log.
The repository URL is located at: http://autoinstall-win.pp.parallels.com
If you want to specify any custom locations such as the vhosts location for the Parallels Plesk
Panel, before the installation add into the \PLESK\PSA Config\Config registry key the
following string values:
• PRODUCT_ROOT_D - panel installation path
• PRODUCT_DATA_D - panel data storage path
• HTTPD_VHOSTS_D - vhosts path