Nov 8, 2018

How to fix MySQL: Got fatal error 1236 from master when reading data from binary log: 'Misconfigured master - server id was not set'

Try setting master server_id dynamically via mysql CLI using set global server_id=xxx

mysql> SET GLOBAL server_id = 198;
Query OK, 0 rows affected (0.04 sec)

Verify the server id seems to have taken effect:

mysql> SHOW GLOBAL VARIABLES like 'server\_id';
| Variable_name | Value |
| server_id     | 198   |
1 row in set (0.00 sec)

After setting it, going back to the slave and setting up the master again.