Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/security-advisors-ref.html
Default frequency 06:00:00 Default auto-close enabled no LOCAL Option Of LOAD DATA Statement Is Enabled The LOAD DATA statement can load a file that is located on the server host, or it can load a file that is located on the client host when the ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-user-accounts.html
The following statements create user accounts named 'user1'@'203.0.113.11' and 'user1'@'203.0.113.12, where 203.0.113.11 and 203.0.113.12 are the IP addresses of the client hosts. The statements include security-related options for enabling ...It ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
Running Auto Parallel Load involves issuing a CALL statement for the stored procedure, which takes schemas and options as arguments. For example: mysql> CALL sys.heatwave_load(JSON_ARRAY("tpch"), JSON_OBJECT("mode","normal")); Note Retrieve DDL ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Batch mode can ...Why use a script? Here are a few reasons: If you run a query repeatedly (say, every day or every week), making it a script enables you to avoid retyping it each time you execute ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
The server populates the server-side help tables used for the HELP statement (see Section 15.8.3, “HELP Statement”). If the init_file system variable was given to name a file of SQL statements, the server executes the statements in the file.
https://dev.mysql.com/doc/refman/8.4/en/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The definition of an existing event can be changed by means of the ALTER EVENT statement. When a scheduled event is no ...Whether an event persists past the end of its schedule also depends on its ON COMPLETION clause, if it has ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-cloning.html
An automatic start of Group Replication on server boot (including after a remote cloning operation) would use the stored user credentials, and they would also be used if an operator did not specify the distributed recovery credentials on a START ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
However, if every member of a replication group leaves the group, and Group Replication is stopped on every member by a STOP GROUP_REPLICATION statement or system shutdown, the group now only exists in theory, as a configuration on the members. If ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
The exception to this rule is that the query sees the changes made by earlier statements within the same transaction. Consistent read is the default mode in which InnoDB processes SELECT statements in READ COMMITTED and REPEATABLE READ isolation ...
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN authentication_kerberos SONAME 'authentication_kerberos.so'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to ...