Search Results
https://dev.mysql.com/doc/refman/8.4/en/keyring-file-component.html
Keyring operations performed by those functions are accessible in SQL statements as described in Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”. The component_keyring_file keyring component stores keyring data in a file ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
In this case, it may be necessary to connect to the running server and enable keyring_operations manually using this statement: SET GLOBAL keyring_operations = ON; Online key migration provides for pausing keyring operations on a single running ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-metadata.html
To see whether a keyring plugin is loaded, check the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). If the component loaded but failed to initialize, the value is ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
Keyring operations performed by those functions are accessible at two levels: SQL interface: In SQL statements, call the functions described in Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”. Note The keyring_okv plugin is ...
https://dev.mysql.com/doc/refman/8.4/en/keyring.html
This service is accessible at two levels: SQL interface: In SQL statements, call the functions described in Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”. MySQL Server supports a keyring that enables internal server ...
https://dev.mysql.com/doc/refman/8.4/en/language-structure.html
This chapter discusses the rules for writing the following elements of SQL statements when using MySQL: Literal values such as strings and numbers Identifiers such as database, table, and column names Keywords and reserved words User-defined and ...
https://dev.mysql.com/doc/refman/8.4/en/locale-support.html
The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names ...
https://dev.mysql.com/doc/refman/8.4/en/logical-operators.html
For example, the following statements all assess to TRUE: mysql> SELECT 10 IS TRUE; -> 1 mysql> SELECT -10 IS TRUE; -> 1 mysql> SELECT 'string' IS NOT NULL; -> 1 NOT, ! Logical NOT. Table 14.5 Logical Operators Name Description AND, && Logical AND ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. Similarly, ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
To see the values used by a given instance, connect to it and execute a SHOW VARIABLES statement. In some cases, you might want to run multiple instances of MySQL on a single machine. You might want to test a new MySQL release while leaving an ...