Database is not being migrated: "For security reasons data management is not supported for databases, which have no database users assigned"

Symptoms

Domain database is not being migrated, migration completes with the following warning:

Warning:        domain "domain.com"
Failed deployment of database domain_com_lp (domain domain.com)
Warning:        
Failed to attach existing remote database domain_com_lp (domain domain.com). For security reasons data management does not supported for databases, which has no database users assigned

However the domain_com_lp database is located on the local server.

The following error can be observed in the /usr/local/psa/PMM/logs/pmmcli.log

Unable to connect to database using supplied credentials

Cause

Database is not migrated due to credentials issue.

Also such warning may occur if there is no any user created under this database on the source server.

Resolution

First of all check if at least one user exists under this database. If it does then follow the steps below.

1. Create database backups on both source and destination servers:

   mysqldump -uadmin -p` cat /etc/psa/.psa.shadow ` psa > /tmp/psadump.`date +%F_%H.%M`.sql
   mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` mysql  > /tmp/mysqldump.`date +%F_%H.%M`.sql
   mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` --all-databases >   /tmp/all.`date +%F_%H.%M`.sql
   

2. On the source server change user credentials of the domain_com_lp database: go to Subscriptions > domain.com > Websites & Domains > Databases > domain_com_lp > domain_com_lp_user

3. On the destination server drop the database in question:

   mysql> drop database domain_com_lp
   

4. Try to migrate one more time.