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/user-names.html
MySQL stores accounts in the user table of the mysql system database. You should never alter the structure of tables in the mysql database in any manner whatsoever except by means of the procedure that is described in Chapter 3, Upgrading MySQL. To ...An account is defined in terms of a user name and the client host or hosts from which the user can connect to the ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html
By default, audit log filter definitions are stored in the mysql system database, and you can display audit filters by querying the mysql.audit_log_filter table. To grant one of these privileges to a user account, use this statement: GRANT privilege ... Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...
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 ...