Search Results
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
MySQL privileges differ in the contexts in which they apply and at different levels of operation: Administrative privileges enable users to manage operation of the MySQL server. In replication context, the PASSWORDLESS_USER_ADMIN privilege applies ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
CREATE FUNCTION GTID_INTERSECTION(gs1 LONGTEXT, gs2 LONGTEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(gs1, GTID_SUBTRACT(gs1, gs2)) | This function returns the symmetric difference between two GTID sets, that is, the GTIDs that exist in gs1 but not in ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
noblob: Log all columns (same as full), except for BLOB and TEXT columns that are not required to identify rows, or that have not changed. This system variable cannot be changed within the context of a transaction. This system variable cannot be ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
Create a text file containing the password-assignment statement on a single line. Create a text file containing the password-assignment statement on a single line. If you have never assigned a root password for MySQL, the server does not require a ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
All other information is transferred as text, and can be read by anyone who is able to watch the connection. The output of mysqladmin processlist and SHOW PROCESSLIST shows the text of any statements currently being executed, so any user who is ...
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
An INTO clause should not be used in a nested SELECT because such a SELECT must return its result to the outer context. INTO OUTFILE statement is intended to enable dumping a table to a text file on the server host. INTO OUTFILE can also be used ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
--log-raw Command-Line Format --log-raw[={OFF|ON}] System Variable log_raw Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF Passwords in certain statements written to the general query log, slow query log, and binary ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Current_tls_ca The active ssl_ca value in the SSL context that the server uses for new connections. This context value may differ from the current ssl_ca system variable value if the system variable has been changed but ALTER INSTANCE RELOAD TLS has ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
It does not apply to external pages used for TEXT or BLOB entries. Sorted Index Builds and Full-Text Index Support Sorted index builds are supported for fulltext indexes. Previously, SQL was used to insert entries into a fulltext index. InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...