Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
The AUDIT_ABORT_EXEMPT privilege is also assigned to existing accounts with the SYSTEM_USER privilege when you carry out an upgrade procedure, if no existing accounts have that privilege assigned. For information about using JSON data in MySQL, see ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
The AUDIT_ABORT_EXEMPT privilege is also assigned to existing accounts with the SYSTEM_USER privilege when you carry out an upgrade procedure, if no existing accounts have that privilege assigned. Note For audit log filtering to work as described ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-restrictions.html
Only top-level statements are logged, not statements within stored programs such as triggers or stored procedures. MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as ...
https://dev.mysql.com/doc/refman/8.4/en/backup-and-recovery.html
For additional information about InnoDB backup procedures, see Section 17.18.1, “InnoDB Backup”. It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system ...
https://dev.mysql.com/doc/refman/8.4/en/backup-strategy-example.html
You should include such options as necessary to enable client programs to connect to the MySQL server. Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash recovery. Assume also that the ...
https://dev.mysql.com/doc/refman/8.4/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). A compound statement can contain multiple statements, enclosed by the BEGIN and END keywords.
https://dev.mysql.com/doc/refman/8.4/en/binary-installation.html
These include generic binary distributions in the form of compressed tar files (files with a .tar.xz extension) for a number of platforms, and binaries in platform-specific package formats for selected platforms. This section covers the installation ...
https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html
There are two ways to address this problem: Reduce the number of TCP ports consumed quickly by investigating connection pooling or persistent connections where possible Tune some settings in the Windows registry (see below) Important The following ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...
https://dev.mysql.com/doc/refman/8.4/en/case.html
(The indentation used here in the ELSE clause is for purposes of clarity only, and is not otherwise significant.) DELIMITER | CREATE PROCEDURE p() BEGIN DECLARE v INT DEFAULT 1; CASE v WHEN 2 THEN SELECT v; WHEN 3 THEN SELECT 0; ELSE BEGIN END; END ... CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the source. It also updates the contents of the replication metadata repositories (see Section 19.2.4, “Relay Log ...