Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...The optional ...
https://dev.mysql.com/doc/refman/8.4/en/set-role.html
When a user connects to the server and authenticates successfully, the server determines which roles to activate as the default roles. SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... } SET ROLE modifies the current user's effective ...
https://dev.mysql.com/doc/refman/8.4/en/set-statement.html
SET CHARACTER SET and SET NAMES assign values to character set and collation variables associated with the current connection to the server. Descriptions for those forms that are not associated with a specific server capability appear in subsections ...