https://dev.mysql.com/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/secure-client-programming.html
Have your application connect to the database using a user name different from the one you use for administrative purposes. Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering ...
https://dev.mysql.com/server-configuration.html
The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: shell> ...
https://dev.mysql.com/server-logs.html
MySQL Server has several logs that can help you find out what activity is taking place. (The DDL log is always created when required, and has no user-configurable options; see The DDL Log.) The following log-specific sections provide information ...
https://dev.mysql.com/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/session-state-tracking.html
One use for the tracker mechanism is to provide 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 ...A ...
https://dev.mysql.com/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/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/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/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 ...
