Search Results
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-reference.html
The plugin communicates information to users by setting the table's message column. Users communicate with the plugin by modifying the set of rules stored in this table. The function is intended to be invoked by the stored procedure, not directly by ...Unless that procedure has been called following the most recent table modification, the table contents do not necessarily correspond to the set of rules the plugin is ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-server-compatibility.html
From MySQL Shell 8.0.26, this option also removes user accounts that do not have passwords set, except where an account with no password is identified as a role, in which case it is dumped using the CREATE ROLE statement. strip_restricted_grants ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. This means that a ROLLBACK from the user does not undo CREATE TABLE statements the user made during that transaction. The statements listed in this section (and any ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
row *************************** Id: 2 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 3 State: Waiting for next activation Info: NULL 2 rows in set (0.00 sec) Event scheduling can be stopped by setting the value of ...When ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-connection.html
connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL Server for display as connection attributes in the 'PERFORMANCE_SCHEMA' tables ...Setting ...Example usage: "connectionAttributes=key1:value1,key2:value2" This functionality is available for use with MySQL Server version 5.6 or later ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Exporting privileges for nonexistent users will result in errors when you execute the CREATE script. Forward engineering enables you to create a script of your database model. Only Export Privileges Select this option to update the privileges of ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
When no character set is specified for the return type, JSON_VALUE() uses utf8mb4 with the binary collation, which is case-sensitive; if utf8mb4 is specified as the character set for the result, the server uses the default collation for this ... The ...JSON_CONTAINS(target, candidate[, path]) Indicates by returning 1 or 0 whether a given candidate JSON document is contained within a target JSON document, or—if a path argument was supplied—whether the candidate is found at a specific path within the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
@bank_model is the name of the user-defined session variable that stores the model handle for the duration of the connection. Load Data into an External Lakehouse Table After uploading the file to Object Storage, set up the name of the table that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
The REPLICATION_APPLIER privilege explicitly or implicitly allows the PRIVILEGE_CHECKS_USER account to carry out the following operations that a replication thread needs to perform: Setting the value of the system variables gtid_next, ... The user ...The REQUIRE_ROW_FORMAT setting can be applied to secured channels, which restricts the channel from executing events that would require these ...Executing ...As explained in Section 19.3.3, ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-TLS-connections-clusters.html
Then follow the steps for a basic or a user-defined setup. Create a new cluster with TLS enabled on initial startup Create a site, package, and a cluster with the desired configuration—see Section 4.4, “Setting Up MySQL NDB Clusters with MySQL ... MySQL Cluster Manager 8.4 supports TLS Link Encryption for NDB Cluster, which is available for NDB Cluster 8.3.0 and ...