Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-resource-group.html
If the resource group or any named thread ID does not exist, an error occurs. SET RESOURCE GROUP group_name [FOR thread_id [, thread_id] ...] SET RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource Groups”).
https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. It takes ...
https://dev.mysql.com/doc/refman/8.4/en/setting-environment-variables.html
If your shell is tcsh, add the following line to your .tcshrc file: setenv PATH ${PATH}:/usr/local/mysql/bin If the appropriate startup file does not exist in your home directory, create it with a text editor. Environment variables can be set at ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
Installing SHA-256 Pluggable Authentication The sha256_password (deprecated) plugin exists in server and client forms: The server-side plugin is built into the server, need not be loaded explicitly, and cannot be disabled by unloading it. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-logs.html
Existing binary log files are not encrypted or decrypted if binary log encryption is activated or deactivated while the server is running. SHOW BINARY LOGS Lists the binary log files on the server. This statement is used as part of the procedure ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-user.html
SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. The statement requires the SELECT privilege for the mysql system schema, except to see information for the current user. For the current user, the ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
For example, if an anonymous account exists, the named account might be able to use its privileges, but SHOW GRANTS does not display them. SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, ...
https://dev.mysql.com/doc/refman/8.4/en/show-relaylog-events.html
If no channel is named and no extra channels exist, the statement applies to the default channel. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
Without SIGNAL, it is necessary to resort to workarounds such as deliberately referring to a nonexistent table to cause a routine to return an error. Example: CREATE PROCEDURE p (divisor INT) BEGIN DECLARE divide_by_zero CONDITION FOR SQLSTATE ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
When WITH_ANT is not set, or is set with the special value system, the build process assumes a binary ant exists in $PATH. The CMake program provides a great deal of control over how you configure a MySQL source distribution. Typically, you do this ...