Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-load-data.html
If you need to recover from a replication error involving a LOAD DATA INFILE operation logged in statement format, and the replicated event is trusted, you could grant the FILE privilege to the PRIVILEGE_CHECKS_USER account temporarily, removing it ... LOAD DATA is considered unsafe for statement-based logging (see Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-mysqldb.html
However, statements that would normally update this information indirectly—such GRANT, REVOKE, and statements manipulating triggers, stored routines, and views—are replicated to replicas using statement-based replication. Data modification ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, event, view, user, role, or grant. The life cycle of a GTID consists of the following steps: ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-configuration.html
A multi-source replication topology requires at least two sources and one replica configured. In these tutorials, we assume that you have two sources source1 and source2, and a replica replicahost. The replica replicates one database from each of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-table-options.html
For example, a GRANT statement, which updates the mysql.user system table but does not mention that table, is not affected by a filter that specifies mysql.% as the wildcard pattern. The replica checks for and evaluates table options only if either ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
Granting CAP_SYS_NICE capability to a process enables a range of privileges; consult http://man7.org/linux/man-pages/man7/capabilities.7.html for the full list. MySQL supports creation and management of resource groups, and permits assigning ...
https://dev.mysql.com/doc/refman/8.4/en/security-options.html
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”.
https://dev.mysql.com/doc/refman/8.4/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
If an account is to be permitted to manipulate secondary passwords for all accounts, it should be granted the CREATE USER privilege rather than APPLICATION_PASSWORD_ADMIN. SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-procedure.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...