The "Public Key Retrieval is not allowed" error is returned in the DTS migration test -

Problem description

When DTS is used to migrate data, the user-created database is used as the source database and non-encrypted is selected for connection method. The following error is returned when you test the connection.

Public Key Retrieval is not allowed

Solution

Change the value of my.conf in the default_authentication_plugin configuration file of the user-created MySQL database to mysql_native_password, change the password encryption mode to the previous mode, and restart the database.
Run the following SQL ALTER statement to reset the password and overwrite the password of the new encryption method:

Note: the root user or connected users need to perform this step because this user is still using the new encryption method.
```
ALTER USER '[$User]'@'[$Host]' IDENTIFIED WITH mysql_native_password BY '[$Password]';
```
Note:
- [$User] is the User name.
- [$Host] is the logon address.
- [$Password] is the user Password.

Scope

Data Transmission Service (DTS)