Syntax error What are the special security requirements for using stored procedures and functions together with replication?

What are the special security requirements for using stored procedures and functions together with replication?

Actually, a MySQL slave server has the authority to execute any statement read from a master's MySQL server binary log, hence some special security constraints exist for using stored functions with replication. If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them −

Option of SUPER privilege

Any user wishing to create stored functions must be granted the SUPER privilege by DBA.

log_bin_trust_function_creators mode

Actually, log_bin_trust_function_creators enables anyone with the standard CREATE ROUTINE privilege to create stored functions hence a DBA can set the log_bin_trust_function_creators system variable to 1.

Updated on: 2020-06-22T07:23:52+05:30

244 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements