Search Results
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
The MySQL server reads the contents of the grant tables into memory when it starts, and reloads them under the circumstances indicated in Section 8.2.13, “When Privilege Changes Take Effect”. MySQL privileges differ in the contexts in which they ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
A companion section lists MySQL server options and variables that have been added, deprecated, or removed in MySQL 8.4; see Section 1.5, “Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.4 since 8.0”. To enable ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are compressed. For additional information and ...Command Options for Connection Establishment Command Options for Encrypted Connections Command Options for Connection Compression Command Options for Connection Establishment This section describes options that control how client programs establish connections to the ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
If enabled, read-only queries are directed to read-only servers, and read-write queries are directed to read-write servers. protocol Type String Default Value classic Valid Values classic x Used by the routing plugin when connecting to the ... When ...Detailed information about each of these options, such as descriptions and allowed values, is documented below these ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
A value of DEFAULT, which is the default setting, means joining members use the existing member's standard SQL client connection, as specified by MySQL Server's hostname and port system variables. A summary of the requirements is as follows: The IP ...For example, in InnoDB Cluster, the default value of group_replication_communication_stack is MYSQL, not XCOM as it is for a default Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
When a MySQL account authenticates using LDAP, MySQL server attempts to establish a TCP connection with the LDAP server, which it uses to send an LDAP bind request over the connection. When a MySQL account authenticates using LDAP, MySQL server ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-deploy.html
A sandbox deployment is where all the MySQL server instances and other software run on a single machine. A number of standalone MySQL Server instances (which are not part of an InnoDB Cluster or InnoDB ReplicaSet) to make into one or more replica ...
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
This changes the password to new_password for the account that you use with mysqladmin for connecting to the server. MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. The return ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-routing-guidelines-examples.html
MySQL Version-specific Routing MySQL Version Specific Routing is useful when certain applications or sessions need to connect to servers with a specific MySQL version. This guideline directs read-write and read-only traffic to servers with specific ...When bootstrapping MySQL Router, --conf-target-cluster can be used to specify the name of the InnoDB Cluster that is considered local to the ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Tc_log_max_pages_used For the memory-mapped implementation of the log that is used by mysqld when it acts as the transaction coordinator for recovery of internal XA transactions, this variable indicates the largest number of pages used for the log ... The MySQL server maintains many status variables that provide information about its ...mysql> SHOW GLOBAL STATUS; +-----------------------------------+------------+ | Variable_name | Value | +-----------------------------------+------------+ | Aborted_clients | 0 ...