Search Results
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/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 ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-fault.html
When the member joining has restarted at the end of the operation, it establishes a connection with a new donor for state transfer from the binary log, which might be a different member from the original donor used for the remote cloning operation.
https://dev.mysql.com/doc/refman/8.4/en/ipv6-support.html
Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over IPv6. For example, this command connects over IPv6 to the MySQL server on the local host: $> mysql -h ::1 To use this ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-options.html
Migration always occurs on the local host, so the option always specifies a value for connecting to a local server, such as localhost, 127.0.0.1, ::1, or the local host IP address or host name. --keyring-migration-password[=password] Command-Line ...
https://dev.mysql.com/doc/refman/8.4/en/load-data-local-security.html
In this environment, the client with respect to the MySQL server actually is the Web server, not a remote program being run by users who connect to the Web server. To avoid connecting to untrusted servers, clients can establish a secure connection ... The LOAD DATA statement loads a data file into a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-api.html
AutoReconnect: Specifies whether an API node should reconnect fully when disconnected from cluster. ConnectBackoffMaxTime: Specifies longest time in milliseconds (~100ms resolution) to allow between connection attempts to any given data node by this ... The listing in this section provides information about parameters used in the [mysqld] and [api] sections of a config.ini file for configuring NDB Cluster SQL nodes and API ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-top.html
Usage ndb_top [-h hostname] [-t port] [-u user] [-p pass] [-n node_id] ndb_top connects to a MySQL Server running as an SQL node of the cluster. By default, it attempts to connect to a mysqld running on localhost and port 3306, as the MySQL root ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) Disabling mysql Auto-Reconnect mysql Client Parser Versus Server Parser Input-Line Editing mysql ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
The user connects to the server using an encrypted connection and supplies an SSL certificate with the designated Subject value. Such a user then connects to the server with the certificate and any other SSL options required to establish an ... SET ...