Switch MySQL slave to master - BINLOG_FORMAT

Question

I had a mySQL slave db that turned into master once some server migration done. Now, when I do a mySQL restart, the db turnos on with the

BINLOG_FORMAT = STATEMENT

So I am not able to write in the DB.

How can I move my mySQL db to be a full master db?

Thank you.

Answer 1

you need to enable binary log on this server by:

log_bin=1
BINLOG_FORMAT = STATEMENT  / MIXED / ROWS