3245
MariaDBERRORCommonReplicationHIGH confidence

Replication source password exceeds maximum length

Production Risk

High — replication IO thread cannot start, causing replication lag.

How to reproduce
trigger — this will error
trigger — this will error
CHANGE REPLICATION SOURCE TO SOURCE_PASSWORD='averylongpasswordthatexceedsthirtytwocharslimit';

expected output

ERROR 3245 (HY000): The replication receiver thread cannot start because the source password exceeds the maximum length.

Fix

Shorten the password

Shorten the password
ALTER USER 'repl'@'%' IDENTIFIED BY 'ShortPass123!';

Why this works

Reset the replication user password to 32 characters or fewer.

What not to do

Sources
Official documentation ↗

MySQL 8.0 — 3245 ER_CHANGE_SOURCE_PASSWORD_LENGTH

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors