3245
MySQLERRORCommonReplicationHIGH 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