- Plesk for Linux
- Plesk for Windows
An application was installed for a domain and removed later: it is no longer present in the Domains > example.com > Applications
The database of the application is still presented in Domains > example.com > Databases
Remove button in Domains > example.com > Databases is disabled:
Database user cannot be selected for removal in Domains > example.com > Databases > User Management:
Database inconsistency: the application has been removed, but the relation to the database and user persists.
Connect to the server via SSH
Remove the relations between the APS registry and database and its user using their names:
# DELETE a FROM apsResources a LEFT JOIN db_users d ON a.pleskId=d.id LEFT JOIN data_bases db ON a.pleskId=db.id WHERE d.login='exampleuser' AND db.name='exampledb';
After that, it will become possible to remove the database user and the database.