What is the effect of adding a user on a MySQL slave?

Question

This is on a Ubuntu 12.04 server running MySQL 5.5 which is slaved to an OS X server running MySQL 5.1

Logrotate has been sending

error: error running shared postrotate script for '/var/log/mysql.log /var/log/mysql
/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/error.log '

Turns out that there's supposed to be a "debian-sys-maint" MySQL user. I'd imagine that got blown away when the master database was imported.

My question is: Is it all right to re-add the "debian-sys-maint" user to the slave, or do I need to add it to the master?

score 2 · Answer 1 · answered Jul 20 '13 at 04:17

2

You must add it to the master or it'll get blown away again when the database replicates over.

answered Jul 20 '13 at 04:17

Nathan C

15,059
4
43
62

Is your `mysql` database replicated? – sendmoreinfo Jul 20 '13 at 10:14
It is a slave to the OS X database. – Ironlenny Jul 22 '13 at 04:57

score 0 · Accepted Answer · answered Jul 24 '13 at 10:49

0

I found out the slave was not set to replicate the mysql database, so the user won't get blown way when the slave updates.

answered Jul 24 '13 at 10:49

Ironlenny

203
1
3
8

What is the effect of adding a user on a MySQL slave?

2 Answers2