PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
[IGNORE UNKNOWN USER] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names” } The REVOKE statement enables system administrators to revoke privileges and roles, which can be ...[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ...
https://dev.mysql.com/doc/refman/8.0/en/xa-restrictions.html
The events_transactions_current table displays the current status of the most recent monitored transaction event on the thread, and does not update this status when the thread is idle. For “external XA,” a MySQL server acts as a Resource Manager ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/charset-literal.html
Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system ...It tells the parser, “the string that follows uses character set charset_name.” An introducer does not change the string to the introducer character set like CONVERT() would ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting transactions that can (and sometimes should) be used instead of sending a START TRANSACTION statement from the client. This means ...
https://dev.mysql.com/doc/refman/8.0/en/connectors-apis.html
Both Connectors and the APIs enable you to connect and execute MySQL statements from another language or environment, including ODBC, Java (JDBC), C++, Python, Node.js, PHP, Perl, Ruby, and C. Connector/J provides driver support for connecting to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transactions.html
In general, you should avoid transactions that update both transactional and nontransactional tables in a replication environment. A statement that references both nontransactional and transactional tables and updates any of the tables involved is ...You should also avoid using any statement that accesses both transactional (or temporary) and nontransactional tables and writes to any of ...The server uses ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
validate_password.dictionary_file can be set at runtime and assigning a value causes the named file to be read without a server restart. This section describes the system and status variables that validate_password provides to enable its operation ...This applies only when changing an existing password, and has no effect when setting a user account's initial ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. EXPLAIN ANALYZE can be used with SELECT statements, as ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer.html
It is downloaded with and supports the following MySQL products: MySQL Servers MySQL Installer can install and manage multiple, separate MySQL server instances on the same host at the same time. Each time you invoke MySQL Installer, the ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
The plugin opens each remaining candidate file, verifies that the file actually contains JSON audit events, and sorts the files using the timestamps from the first event of each file. For example, pass a bookmark, which is a JSON hash containing ...