How to register an existing database in Plesk

Question

A database exists in a database server, but is absent in Plesk at Domains > example.com > Databases.

How to register an existing database in Plesk?

Answer

Below are common examples of registering existing databases.

To see all available commands for registering existing databases, see:

• For Linux:
  Reference for Command-Line Utilities, Plesk for Linux: database

• For Windows:
  Reference for Command-Line Utilities, Plesk for Microsoft Windows: database.exe

Contents

• Registering an existing local MySQL database in Linux
• Registering an existing remote MySQL/MSSQL database in Windows

Registering an existing local MySQL database in Plesk for Linux

1. Connect to a Plesk server via SSH.

2. Register an existing database in Plesk with the command:

   # plesk bin database --register db_name -domain example.com -server 203.0.113.2:3306

   where:

   • db_name - a database name
   • example.com - a domain name to which the database is going to be attached
   • 203.0.113.2:3306 - a default MySQL server IP address and its port

3. Register an existing database user with the command:

   # plesk bin database --register-dbuser db_user -domain example.com -database db_name -type mysql -user-role readWrite -passwd "<password>"

   where:

   • db_user - a database username
   • example.com - a domain name specified on step 2
   • db_name - a database name specified on step 2
   • <password> - a password of the database user

Registering an existing remote MySQL/MSSQL database in Plesk for Windows

1. Connect to a Plesk server via RDP.

2. Make sure that a database server is registered in Plesk at Tools & Settings > Database Servers.

3. Start a command prompt as an Administrator.

4. With the command below, register a database in Plesk and assign it to a domain:

   C:\> plesk bin database.exe --register db_name -domain example.com -server 203.0.113.2

   where:

   • db_name - a database name
   • example.com - a domain name to which the database is going to be attached
   • 203.0.113.2 - an IP address of a remote database server. It can also be a hostname

5. Register a database user in Plesk and assign it to the database:

   C:\> plesk bin database.exe --register-dbuser db_user -domain example.com -database db_name -type mssql -user-role readWrite -passwd "<password>" -server 203.0.113.2

   where:
   • db_user - a database username
   • example.com - a domain name specified on step 4
   • db_name - a database name specified on step 4
   • mssql - a type of the MSSQL database. To register a MySQL database, use mysql
   • <password> - a password of the database user
   • 203.0.113.2 - an IP address of a remote database server. It can also be a hostname