log_bin_trust_function_creators
If set to FALSE (the default), then when --log-bin is used, creation of a stored function (or trigger) is allowed only to users having the SUPER privilege and only if this stored function (trigger) may not break binary logging. Note that if ALL connections to this server ALWAYS use row-based binary logging, the security issues do not exist and the binary logging cannot break, so you can safely set this to TRUE
See also: System Variables in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
DETAILS
PARAMETERS
Command-line |
--log_bin_trust_function_creators[={OFF| |
Configuration file |
Supported |
Dynamic |
Yes |
Scope |
Global |
Data Type |
BOOLEAN (OFF, ON) |
Default Value |
OFF |
SKYSQL
Cloud |
SkySQL Topology |
ES Ver |
Default |
---|---|---|---|
AWS |
HA (Primary/Replica) |
10.4 |
ON |
AWS |
HA (Primary/Replica) |
10.5 |
ON |
AWS |
Transactional Standalone |
10.4 |
ON |
AWS |
Transactional Standalone |
10.5 |
ON |
AWS |
Distributed Transactions |
10.5 |
ON |
GCP |
ColumnStore |
10.5 |
OFF |
GCP |
ColumnStore Multi |
10.5 |
OFF |
GCP |
Galera |
10.4 |
ON |
GCP |
Galera |
10.5 |
ON |
GCP |
HA (Primary/Replica) |
10.4 |
ON |
GCP |
HA (Primary/Replica) |
10.5 |
ON |
GCP |
HTAP |
10.5 |
OFF |
GCP |
Transactional Standalone |
10.4 |
ON |
GCP |
Transactional Standalone |
10.5 |
ON |
GCP |
Distributed Transactions |
10.5 |
ON |
See MariaDB SkySQL documentation to learn more about the MariaDB SkySQL database as a service.
CHANGE HISTORY
Release Series |
History |
---|---|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
Information specific to MariaDB SkySQL can be found on the log_bin_trust_function_creators page in the SkySQL Documentation.