Migration fails: ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it

Symptoms

• MySQL databases are not migrated to Windows server with MariaDB 10.11

• Migration fails with the following error:

  Failed to copy content of database 'wp_test85'
  Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code.
  command: "C:\Program Files (x86)\Plesk\MySQL\bin\mysql" --no-defaults -h localhost -P 3306 -uroot -p***hidden*** --default-character-set=utf8 wp_test85 -e "source C:\Program Files (x86)\Plesk\var\modules\panel-migrator\sessions\20241112210236\target-server\db_backup_pleskexample.com_wp_test85.sql"
  exit code: 1
  stdout:
  stderr: ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it

Cause

This behavior is caused by Plesk bug PMT-5409

Resolution

1. Connect to the Windows Server via RDP

2. Remove the --no-defaults option from the command in line 1141 of the file: %plesk_dir%\admin\plib\modules\panel-migrator\backend\lib\python\parallels\core\utils\database_utils.py

CONFIG_TEXT: with db_server.runner() as runner:
    assert isinstance(runner, BaseRunner)
    runner.execute_command(
        '{mysql_client} --no-defaults -h {host} -P {port} -u{login} -p{password} --default-character-set=utf8 {database_name} '
        '-e {query}',
        dict(

3. Resync the affected subscriptions