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.

Comments

Popular posts from this blog

How to get Active Transactions and Locks from MySQL

Example of a PAC file