- Plesk Onyx for Linux
Сustomized database user's permissions are not saved when the website is migrated via Plesk > Extensions > Site import extension.
The behavior is expected: Site Import extension migrate only files and database content.
An absence of corresponding warning was considered as Plesk bug #PMT-4572 that will be fixed in future product updates.
For including the feature of importing user privileges in Site import extension, vote for it on Plesk UserVoice portal.
Change database user privileges manually:
- Connect to the server via SSH
- Enter database server:
# plesk db
- Change privileges of required database user according to MySQL documentation. For example, grant all privileges for database user "user" of database "databasename":
CONFIG_TEXT: mysql> GRANT ALL PRIVILEGES ON databasename.* TO 'user'@'%'