Error
Error Code:
1763
MySQL Error 1763: Replica Authentication Mismatch
Description
This error occurs when attempting to configure replication authentication options (like SSL/TLS or user credentials) while specifically starting only the replica's SQL thread. The SQL thread is responsible for applying transactions, not for establishing the secure connection to the source server where authentication is configured.
Error Message
Setting authentication options is not possible when only the Replica SQL Thread is being started.
Known Causes
3 known causesUsing Auth Options with SQL_THREAD
The `START REPLICA SQL_THREAD` command only controls the application of events, not the network connection where authentication parameters are relevant.
Misunderstanding Replication Thread Roles
Authentication options are handled by the I/O thread, which establishes the connection to the source, not the SQL thread which processes transactions.
Attempting to Set Secure Options Post-Connection
Secure connection settings, such as SSL/TLS parameters, must be configured when the replica's I/O thread is initiated or altered, not when only the SQL thread is being started.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service