Search Results
https://dev.mysql.com/doc/refman/8.4/en/option-file-options.html
(For information about the order in which option files are used, see Section 6.2.2.2, “Using Option Files”.) If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
It is also possible for an administrative user to reset the account password, but any existing restricted sessions for that account remain restricted. The RETAIN CURRENT PASSWORD and DISCARD OLD PASSWORD clauses have the following effects: RETAIN ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-status-table.html
SERVICE_STATE ON (thread exists and is active or idle), OFF (thread no longer exists), or CONNECTING (thread exists and is connecting to the source). This table shows the current status of the I/O thread that handles the replica's connection to the ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication-system-variables.html
The file must exist and contain a valid key for the service principal name (SPN) or authentication of clients will fail. For example, modifying the LDAP server host, port, or TLS settings does not affect existing connections. For example, modifying ...The file name should be given as an absolute path ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
Authentication Plugin Connector-Writing Considerations Various implementations of the MySQL client/server protocol exist. If the protocol implementation used by the client tries to load the default plugin and that plugin does not exist on the client ... When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. You can rename tables locked with a LOCK TABLES statement, ...
https://dev.mysql.com/doc/refman/8.4/en/rename-user.html
An error occurs for old accounts that do not exist or new accounts that already exist. (That is, the statement fails if renaming an account would cause a stored object to become orphaned.) To perform the operation anyway, you must have the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
You can use the asynchronous connection failover mechanism to establish an asynchronous (source-to-replica) replication connection to a new source automatically, after the existing connection from a replica to its source fails. The same replication ...The asynchronous connection failover mechanism can be used to keep a replica synchronized with multiple MySQL servers or groups of servers that share ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-howto.html
Ideally, wait for the server to purge all binary logs, and wait for any existing backup to expire. Before proceeding, you must be sure that transactions without GTIDs do not exist anywhere in the topology. Existing backups that were made before you ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
The gtid_purged System Variable The set of GTIDs in the gtid_purged system variable (@@GLOBAL.gtid_purged) contains the GTIDs of all the transactions that have been committed on the server, but that do not exist in any binary log file on the server.