Search Results
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-installation.html
To install the component, issue this INSTALL COMPONENT statement: INSTALL COMPONENT "file://component_enterprise_encryption"; INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to ... The functions are provided by a MySQL component component_enterprise_encryption, and installing the component installs all of the ...
https://dev.mysql.com/doc/refman/8.4/en/event-scheduler.html
Section 27.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. Stored routines require the events data dictionary table in the mysql system database. The MySQL Event Scheduler manages the ...
https://dev.mysql.com/doc/refman/8.4/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
This ensures that the data node can run in a stable manner without using swap memory, so that NDB can be used for latency-sensitive (realtime) applications. It also holds table rows as they are updated, before the next commit writes them to data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-rpm.html
This section covers the steps necessary to install the correct executables for each type of NDB Cluster node using RPM packages supplied by Oracle. The RPM installer should take care of general configuration issues (such as creating the mysql user ...As an alternative to the method described in this section, Oracle provides MySQL Repositories for NDB Cluster that are compatible with many common Linux ...
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. Attempts to create a new user account or to alter an existing user account identified with mysql_native_password also fail and emit an error. mysql> CREATE USER ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/8.4/en/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-charset.html
The following applies to replication between MySQL servers that use different character sets: If the source has databases with a character set different from the global character_set_server value, you should design your CREATE TABLE statements so ...