https://dev.mysql.com/accounts-table.html
The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current and total number of connections. For a description of how the Performance Schema maintains rows in this table, ...To set the table size explicitly, set the performance_schema_accounts_size system variable at server ...
https://dev.mysql.com/blocked-host.html
If the following error occurs, it means that mysqld has received many connection requests from the given host that were interrupted in the middle: Host 'host_name' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' ...For more information about how the host cache works, see Section 8.12.4.2, “DNS Lookup Optimization and the Host ...
https://dev.mysql.com/c-api-optional-metadata.html
Clients can indicate on a per-connection basis that result set metadata is optional and that the client will indicate to the server whether to return it. There are two ways to indicate that result set metadata is optional for a connection. They are ... When a client executes a statement that produces a result set, MySQL by default makes available both the data the result set contains, and result set metadata that provides information about the result set ...
https://dev.mysql.com/charset-introducer.html
Escapes are always interpreted by the parser according to the character set given by character_set_connection. If _charset_name is not specified but COLLATE collation_name is specified: For a character string literal, the connection default ... A ...
https://dev.mysql.com/clone.html
Connecting to the donor MySQL server instance through MySQL Router is also not supported.) IDENTIFIED BY 'password' specifies the password of the clone user on the donor MySQL server instance. [REQUIRE [NO] SSL] explicitly specifies whether an ...
https://dev.mysql.com/encryption-functions.html
Their return value is a string that has a character set and collation determined by the character_set_connection and collation_connection system variables. Caution Passwords or other sensitive values supplied as arguments to encryption functions are ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/explain.html
When EXPLAIN is used with FOR CONNECTION connection_id rather than an explainable statement, it displays the execution plan for the statement executing in the named connection. See Section 8.8.4, “Obtaining Execution Plan Information for a Named ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...
https://dev.mysql.com/firewall-usage.html
For a connection from a registered account, the firewall converts each incoming statement to normalized form and processes it according to the account mode: In recording mode, the firewall adds the normalized statement to the account whitelist rules. Connect to the MySQL server using the registered account and execute statements to be ... Before using MySQL Enterprise Firewall, install it according to the ...
https://dev.mysql.com/flush.html
They enable the applicable flush operations to be performed without having to connect to the server (which for these operations requires an account that has the RELOAD privilege). Flush the host cache if some of your hosts change IP address or if ...
https://dev.mysql.com/grant-tables.html
For example, a user table row with Host and User values of 'h1.example.net' and 'bob' applies to authenticating connections made to the server from the host h1.example.net by a client that specifies a user name of bob. Similarly, a db table row with ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
