Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Migration and Synchronization from MySQL to MySQL> Full Phase Error: CANNOT UPDATE USER WITH NULL PASSWORD
Updated on 2023-01-17 GMT+08:00
View PDF

Full Phase Error: CANNOT UPDATE USER WITH NULL PASSWORD

Scenarios

During a full migration or synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: retry structures failed events=the fail structures are [type=account, index=0, schema_name=mysql, object_name='***']reason:[CANNOT UPDATE USER WITH NULL PASSWORD].

Possible Causes

The source database account password is empty.

Solution

  1. Contact the O&M engineers to add a password for the account that reports the error in the source database.
  2. In the task list, locate the target task and click Resume in the Operation column to resume the task.