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

In fact, the MySQL slave server has the authority to execute any statement read from the master server's MySQL server binary log, so there are some specialities in using stored functions with replication. security restrictions. If general replication or binary logging (for point-in-time recovery purposes) is active, there are two security options available to the MySQL DBA -

Super privilege option h2>

Anyone wishing to create Users who store functions must obtain the DBA's SUPER authority.

log_bin_trust_function_creators mode

In effect, log_bin_trust_function_creators enables anyone to create stored functions using standard CREATE permissions, so the DBA can set the log_bin_trust_function_creators system variable to 1.

The above is the detailed content of What are the special security requirements for using stored procedures and functions with replication?. For more information, please follow other related articles on the PHP Chinese website!