Search Results
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'rewriter_enabled'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | rewriter_enabled | ON | ... Note If ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
This is also true for statements executed by MySQL client programs including mysqlbinlog, mysqladmin, and mysqldump; for this reason, you should grant SKIP_QUERY_REWRITE to the user account or accounts used by these utilities to connect to MySQL.
https://dev.mysql.com/doc/refman/8.4/en/role-names.html
Specifying a role with a non-'%' host part can be useful if you intend to create a name that works both as a role an as a user account that is permitted to connect from the given host. MySQL role names refer to roles, which are named collections of ...
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
Have your application connect to the database using a user name different from the one you use for administrative purposes. Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or ...
https://dev.mysql.com/doc/refman/8.4/en/server-loadable-functions.html
MySQL Enterprise Edition includes audit logging for monitoring and logging of connection and query activity. MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) ...
https://dev.mysql.com/doc/refman/8.4/en/server-logs.html
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 logging. By default, the server writes files for all enabled logs ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/doc/refman/8.4/en/session-state-tracking.html
The tracker mechanism provides a means for MySQL connectors and client applications to determine whether any session context is available to permit session migration from one server to another. For example, a load-balancing connector managing a ...A ...
https://dev.mysql.com/doc/refman/8.4/en/set-character-set.html
SET CHARACTER SET sets three session system variables: character_set_client and character_set_results are set to the given character set, and character_set_connection to the value of character_set_database. SET {CHARACTER SET | CHARSET} ...
https://dev.mysql.com/doc/refman/8.4/en/set-default-role.html
For each user named immediately after the TO keyword, this statement defines which roles become active when the user connects to the server and authenticates, or when the user executes the SET ROLE DEFAULT statement during a session. SET DEFAULT ...