change MySQL UUID

If you cloned your VM for master slave replication. You will encounter this error.

Fatal error: The slave I/O thread stops because master and slave 
have equal MySQL server UUIDs; these UUIDs must be different for 
replication to work.

Change MySQL UUID

Install UUID

sudo apt-get install uuid

Generate UUID

uuid

Find auto.cnf in your MySQL data directory

stack/mysql/data

Replace the old UUID with your newly generated one. Duh!

Advertisements