PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html
Audit filter definitions are stored in the tables in the mysql system database. To grant one of these privileges to a user account, use this statement: GRANT privilege ON *.* TO user; Alternatively, should you prefer to avoid granting the ... Note ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be needed. Note If you use ALTER DATABASE to change the database default character set or collation, ...If applications require data storage using a different character set or collation, you can configure character set information several ways: Specify character settings per ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
You can also store InnoDB tables in a shared general tablespace, which support multiple tables and all row formats. If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Variables (system variables, user-defined variables, and stored program local variables) are not permitted. Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-schema.html
However, MySQL supports access to data stored in data dictionary tables through INFORMATION_SCHEMA tables and SHOW statements. Upgrading MySQL system tables requires running the full MySQL upgrade procedure. At startup, the data dictionary version ... Data dictionary tables are protected and may only be accessed in debug builds of ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary.html
MySQL Server incorporates a transactional data dictionary that stores information about database objects. In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data ...This ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
Follow this procedure to restart a replication group safely after every member shuts down. You can do this manually by looking at the GTIDs, or you can compare the GTID sets using stored functions, as described in Section 19.1.3.8, “Stored ...
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as identifiers. Internally, identifiers are converted to and are stored as ...Section 11.2.1, “Identifier Length Limits”, indicates the maximum length of each type of ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
Internal Versus External Credentials Storage Some authentication plugins store account credentials internally to MySQL, in the mysql.user system table: caching_sha2_password mysql_native_password (deprecated) sha256_password (deprecated) Most ...