Symptoms
-
The button "Add Database" is missing at Subscriptions > example.com > Databases.
-
Unable to select MySQL/MariaDB/MS SQL database server at Subscriptions > example.com > Databases > Add Database > Database server.
Cause
The number of MySQL/MariaDB/MSSQL databases is limited in the webspace, subscription or reseller plan settings.
Resolution
For Plesk on Linux
-
Connect to the Plesk server via SSH.
-
Increase the database limit (specify "-1" for unlimited):
# plesk bin subscription_settings -u example.com -max_db 100
For Plesk on Windows server
-
Go to Tools & Settings > License Management and check if Microsoft SQL Server support enabled or not:
-
If no, then it is required to purchase the MSSQL support first for the subscription.
MSSQL support is included in the Power Pack and Developer Pack.
-
If yes, then proceed to step 3.
-
-
Run the command below to get the current limit of MS SQL databases for the required webspace:
C:> plesk bin subscription_settings --info example.com | findstr max_mssql_db
max_mssql_db 30 MS SQL databases
-
Increase the number of MSSQL databases for the required webspace (specify "-1" for Unlimited):
C:> plesk bin subscription_settings -u example.com -max_mssql_db 100
-
Go to Subscriptions > example.com > Customize (under Account) > Resources.
-
Find the MySQL/MariaDB/MS SQL databases number:
-
If the subscription has reached its limit, increase it using one the following ways:
- Go to Subscriptions > example.com > Customize > Resources page and increase the MySQL/MariaDB/MS SQL databases limit (changes will affect only this subscription).
- Go to Subscriptions > example.com > Service Plan: Default > Resources page and increase the MySQL/MariaDB/MS SQL databases limit (changes will affect all subscriptions assigned to this service plan and synchronized).
-
If the subscription has not reached the limit, then this limit is set on the reseller's level.
3.1. Go to Subscriptions > example.com > Subscriber: John Doe > Provider: Jane Doe:
- Click the Change Plan button to increase the MySQL/MariaDB/MS SQL databases number for all resellers assigned to this service plan.
- Click the Customize button to increase the MySQL/MariaDB/MS SQL databases number only for this reseller.
3.2. Find the MySQL/MariaDB/MS SQL databases number and increase it to the required value.
-
with