Full Phase Error: transfer account failed, can not find password from src DB

Scenarios

During a full migration, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: transfer account failed, can not find password from src DB.

Possible Causes

The RDS security policy does not allow the user password to be empty. However, if the source database is an on-premises MySQL database, the user password can be empty.

Solution

1. Run the following SQL statement in the source database to query users whose passwords are empty:
   • MySQL 5.7 or later versions:

     SELECT USER,HOST,authentication_string FROM MYSQL.user WHERE authentication_string IS NULL OR authentication_string='';

   • MySQL 5.6 and earlier versions

     SELECT USER,HOST,`password` FROM MYSQL.user WHERE `password` IS NULL OR `password`='';

2. Run the following SQL statement to delete the users whose passwords are empty from the source database or set passwords for the users:
   • Delete a user whose password is empty.

     DROP USER ***@***;

   • Set a password for a user.

     ALTER USER ***@*** IDENTIFIED BY ***;