I started testing MySQL Master-Slave replication in a lab heren.
On the master I enabled binary logging, without setting following:
I then dumed my database and copied it to the slave server.
After starting the Replication, I see that my productive db is replicated.
But what about the following DBs:
- mysql (users, etc.)
Will changes in those DBs also be replicated as soon as I do a change?
Thiat would mean, that my root-account on the slave would change, if I change the root-password on the master.
Is this correct?
How do you handle that?
Must slave and master have the same credentials?
Thanks in advance!