Search Results
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
rewriter_enabled_for_threads_without_privilege_checks System Variable rewriter_enabled_for_threads_without_privilege_checks Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON Valid Values OFF Whether to apply rewrites for ...Users communicate with the plugin by modifying the set of rules stored in this ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
Even with this safeguard, it is better to avoid granting the SYSTEM_USER privilege through a role in order to guard against the possibility of privilege escalation. Like user accounts, roles can have privileges granted to and revoked from them. A ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-defaults.html
To disable a setting, either add a # to the beginning of the line or remove it. The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option files). For general ...
https://dev.mysql.com/doc/refman/8.4/en/server-logs.html
You can enable or disable logging, or change the log file name. MySQL Server has several logs that can help you find out what activity is taking place. The following log-specific sections provide information about the server options that enable ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
REPLICA_SIDE_DISABLED indicates that the creation of the event occurred on another MySQL server acting as a replication source and replicated to the current MySQL server which is acting as a replica, but the event is not presently being executed on ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.4/en/show-plugins.html
Status The plugin status, one of ACTIVE, INACTIVE, DISABLED, DELETING, or DELETED. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
Setting the value to 0 has the practical effect of disabling profiling. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 29.19.1, ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
Sorted Index Builds and Redo Logging Redo logging is disabled during a sorted index build. InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. This method of index creation is also known ...
https://dev.mysql.com/doc/refman/8.4/en/source-ssl-library-configuration.html
Authentication plugins, such as LDAP and Kerberos, are disabled since they do not support these alternative versions of OpenSSL. An SSL library is required for support of encrypted connections, entropy for random number generation, and other ...
https://dev.mysql.com/doc/refman/8.4/en/starting-server-troubleshooting.html
If the data directory is located somewhere else on your system, specify that location with the --datadir option to mysqld or mysqld_safe, on the command line or in an option file. Track down what program this is and disable it, or tell mysqld to ...