Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source.html
Channel specific replication filters can be used when the same database or table is present on multiple sources, and you only need the replica to replicate it from one source. Multi-source replication in MySQL 8.4 enables a replica to receive ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-recover.html
Details of the error and the last applied transaction are recorded in the Performance Schema replication_applier_status_by_worker table. If the PRIVILEGE_CHECKS_USER account should have been permitted to execute the transaction, but has been ... If ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-rawdata.html
You can use any suitable copying or archive utility, including cp, tar or WinZip. Assuming tables have been used for the replica's connection metadata repository and applier metadata repository (see Section 19.2.4, “Relay Log and Replication ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see ... Note This ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
If a role named in mandatory_roles is not present in the mysql.user system table, the role is not granted to users. You should keep in mind that this distinction is not immutable; a user with appropriate privileges can lock or unlock roles or ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
When running MySQL, follow these guidelines: Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql system database! This is critical. To prevent password recovery using rainbow tables, do not use these functions ... Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...
https://dev.mysql.com/doc/refman/8.4/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-view.html
SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...
https://dev.mysql.com/doc/refman/8.4/en/show-variables.html
System variable information is also available from these sources: Performance Schema tables. SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] SHOW VARIABLES shows the values of MySQL system variables (see Section 7.1.8, “Server ...