There is an option called [super_]read_only designed for this use-case: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_read_only h

There is an option called [super_]read_only designed for this use-case: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_read_only https://dev.mysql.com/doc/refman/5.7/en/server-system-variab...