Search Results
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
In addition, you must connect to the server using an encrypted connection and supply an SSL certificate with the Subject value specified by the persist_only_admin_x509_subject system variable. For persist-restricted variables, RESET PERSIST does not ...(For information about dynamic variables, see Section 7.1.9.2, “Dynamic System Variables”.) For certain global system variables, SET can be used to persist their value to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
Each client that connects has its own session time zone setting, given by the session time_zone variable. For example: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql The mysql command shown here assumes that you connect to the ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
Implicit conversion of a numeric or temporal value to string produces a value that has a character set and collation determined by the character_set_connection and collation_connection system variables. For information about connection character ...
https://dev.mysql.com/doc/refman/8.4/en/using-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 10.8.4, “Obtaining Execution Plan Information for a Named ... The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
Limited number of ports Windows systems have about 4,000 ports available for client connections, and after a connection on a port closes, it takes two to four minutes before the port can be reused. In situations where clients connect to and ... The ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-prep-gather.html
When connection and data layout information is available from the configuration file, you no longer need to supply separately most of the information listed below. Before backing up a particular database server for the first time, gather some ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encrypted-innodb.html
Notes Backing up a server that uses a keyring plugin or component other than component_keyring_encrypted_file is only supported for servers that allow socket connections or TCP/IP connections using TLS; it is, therefore, not supported when, for ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
The mysqlbackup command connects to the MySQL server using the credentials supplied with the --user and --password options. Here are the privileges required by mysqlbackup: The minimum privileges for the MySQL user with which mysqlbackup connects ...You can either create a new user with a limited set of privileges, or use an administrative account such as ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/server-repository-options.html
For backups:You do not need to specify this option, because its value is retrieved automatically using the database server connection. For backups: You do not need to specify this option, because its value is retrieved automatically using the ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-add-process.html
Otherwise, MySQL Cluster Manager is unable to connect to the agent processes on those hosts. Any hosts referenced in the list must be members of the site to which the cluster belongs. You are still recommended to follow the best practice of ...