PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/windows-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN authentication_windows SONAME 'authentication_windows.dll'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to ...
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
If necessary, initialize the data directory and create the MySQL grant tables. GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. Windows installation ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-concurrent-ddl.html
DDL operations that are not permitted during a cloning operation regardless of the clone_block_ddl setting include: ALTER TABLE tbl_name DISCARD TABLESPACE; ALTER TABLE tbl_name IMPORT TABLESPACE; ALTER INSTANCE DISABLE INNODB REDO_LOG; . Prior to ...A workaround is to use dedicated donor instances, which can accommodate DDL operations being blocked while data is ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
By extracting a session ticket from an established session and then submitting that ticket while establishing the next connection, the overall cost is reduced if the session can be reused. The following table shows the system variables that define ... As of MySQL 8.0.29, MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
The examples shown here assume use of the latin1 character set and latin1_swedish_ci collation in particular contexts as an alternative to the defaults of utf8mb4 and utf8mb4_0900_ai_ci. To create a database such that its tables use a given default ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...
https://dev.mysql.com/doc/refman/8.0/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. Command Options for Connection ...These options can be given on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
group_replication_advertise_recovery_endpoints specifies how a joining member can establish a connection to an existing member for state transfer for distributed recovery. If an alternative port number is specified by the report_port system ... This ...
https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. Alternatively, you can use the ALTER EVENT statement to set individual events to DISABLE or DISABLE ON SLAVE to prevent them from running on ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-key-rotation.html
When binary log encryption is enabled, you can rotate the binary log master key at any time while the server is running by issuing ALTER INSTANCE ROTATE BINLOG MASTER KEY. The BINLOG_ENCRYPTION_ADMIN privilege is required to issue ALTER INSTANCE ...
https://dev.mysql.com/doc/refman/8.0/en/roles.html
This enables assignment of sets of privileges to accounts and provides a convenient alternative to granting individual privileges, both for conceptualizing desired privilege assignments and implementing them. Instead, use an alternative GRANT syntax ...Like user accounts, roles can have privileges granted to and revoked from ...