- Plesk for Linux
- Plesk for Windows
After migration from cPanel, database users have the complete set of database privileges. Fine-tuned privileges (e.g. SELECT-only, or SELECT + INSERT + UPDATE) are not migrated.
Plesk Migrator bug with ID PMT-4554, which is planned to be fixed in one of the future extension updates.
Tune access to databases manually after migration:
Using Plesk: Log in to Plesk and manage privileges in Subscriptions > example.com > Databases > User Management > john_doe.
Using command-line interface:
- Connect to the server via SSH or RDP
Access Plesk database and run the necessary queries. For example, to grant SELECT, INSERT and DELETE privileges for database
# grant SELECT, INSERT, DELETE ON example_db.* to 'john_doe'@'localhost';