Search Results
https://dev.mysql.com/doc/refman/9.7/en/keyring-hashicorp-plugin.html
The following instructions describe how to create the certificate and key files using OpenSSL. (Optional) To check key file content and validity, use the following commands: openssl rsa -in company.key -check openssl rsa -in vault.key -check Create ... Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-test-and-migrate.html
The following list contains some common errors you may encounter, and their likely causes: MySQL Cluster Manager requires a specific MySQL user and privileges to manage SQL nodes. If the mcmd MySQL user account is not set up properly, you may see No ... Testing and performing the migration of a standalone MySQL NDB Cluster into MySQL Cluster Manager consists of the following steps: Perform a test run of the proposed import using import cluster with the --dryrun ...
https://dev.mysql.com/doc/refman/9.7/en/flush.html
Use access control statements such as CREATE USER, GRANT, REVOKE, as described in Section 8.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”, instead. Frees memory cached by the server as a result of GRANT, CREATE USER, CREATE ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/9.7/en/mle-component-options-variables.html
An MLE session is created within a given MySQL user session once the MySQL user creates or executes a JavaScript stored program. If the MySQL user calls mle_session_reset(), then later creates or executes a JavaScript stored program within the same ...It is dropped when the MySQL user calls mle_session_reset(), or when the MySQL session ... The ...
https://dev.mysql.com/doc/refman/9.7/en/replication-encrypted-connections.html
If you want to ensure that the source only accepts replicas that connect using encrypted connections, create a replication user account on the source using the REQUIRE SSL option, then grant that user the REPLICATION SLAVE privilege. For example: ...
https://dev.mysql.com/doc/refman/9.7/en/replication-multi-source-configuration.html
Create a suitable user account on all the sources that the replica can use to connect. If you create an account solely for the purposes of replication, that account needs only the REPLICATION SLAVE privilege. A multi-source replication topology ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/partial.html
There are various ways to create different kinds of partial backup with MySQL Enterprise Backup: Including or excluding specific tables by their names. For creating partial backups, use the --include-tables and --exclude-tables options instead. To ... By default, all the files under the database subdirectories in the data directory are included in the backup, so that the backup includes data from all MySQL storage engines, any third-party storage engines, and even any non-database files in that ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/configuring-replicaset-instances.html
The preferred method to create users to administer a ReplicaSet is using the setupAdminAccount() operation. When you connect to the instance for administration tasks, you require a user with suitable privileges. Alternatively, the ... Use ...
https://dev.mysql.com/doc/refman/9.7/en/function-resolution.html
ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/9.7/en/invisible-columns.html
However, even if explicitly referenced, a column that is invisible in the existing table is visible in the new table: mysql> CREATE TABLE t1 (col1 INT, col2 INT INVISIBLE); mysql> CREATE TABLE t2 AS SELECT col1, col2 FROM t1; mysql> SHOW CREATE ...