Search Results
https://dev.mysql.com/doc/refman/8.4/en/keyring-options.html
--keyring-migration-user=user_name Command-Line Format --keyring-migration-user=user_name Type String The user name of the MySQL account used for connecting to the running server that is currently using one of the key migration keystores. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-service.html
If there is no user context, this value can be NULL. The value need not actually be a “user”; the meaning depends on the application. Functions that implement the keyring function interface pass the value of CURRENT_USER() as the user_id value ... MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-waiter.html
SINGLE USER MODE: This is shown for all cluster data nodes when the cluster is in single user mode. --single-user The program waits for the cluster to enter single user mode. ndb_waiter repeatedly (each 100 milliseconds) prints out the status of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-auto-sync.html
#!/user/bin/perl -w # file: reset-replica.pl # Copyright (c) 2005, 2020, Oracle and/or its affiliates. It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
Resetting a connection has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and re-authentication is not done. For example: $> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
Optimize the use of spin delay by user threads waiting for flushed redo. innodb_log_wait_for_flush_spin_hwm: Defines the maximum average log flush time beyond which user threads no longer spin while waiting for flushed redo. Consider the following ...
https://dev.mysql.com/doc/refman/8.4/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Account passwords can be expired so that users must reset them. A user who has access to modify the plugin directory (the value of the plugin_dir system variable) or the my.cnf ... Database administrators should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Post-filtering is performed on a per-user basis because individual users select which of the available events are of interest. Reasons to use ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-configuration-table.html
(CHANGE REPLICATION SOURCE TO option: SOURCE_PORT) USER The user name of the replication user account used to connect to the source. (CHANGE REPLICATION SOURCE TO option: SOURCE_USER) NETWORK_INTERFACE The network interface that the replica is bound ... This table shows the configuration parameters used by the replica for connecting to the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
The same replication user account and password must exist on all the source servers in the source list for the channel. In this situation, the replication channel and the replication user account and password for the channel must be set up on all ...