PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
It applies to the authentication factor-related clauses of CREATE USER and ALTER USER statements used to manage MySQL account definitions, where “factor” corresponds to an authentication method or plugin associated with an account: ... The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
Random password generation, as an alternative to requiring explicit administrator-specified literal passwords. To expire an account password manually, use the ALTER USER statement: ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE; This operation ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
ALTER SCHEMA and ALTER TABLESPACE operations do not apply the default_table_encryption setting. An ENCRYPTION clause must be specified explicitly to alter the encryption of an existing schema or general tablespace. The DEFAULT ENCRYPTION clause must ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... You should also be aware of the following effects of ALTER TABLE ... The IGNORE keyword ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
MFA support entails these changes: CREATE USER and ALTER USER syntax has been extended to permit specification of multiple authentication methods. This places constraints on how the authentication-related clauses of CREATE USER and ALTER USER ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
Dropping a partition from a table that is partitioned by either RANGE or by LIST can be accomplished using the ALTER TABLE statement with the DROP PARTITION option. To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr ... Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
innodb_api_enable_mdl Command-Line Format --innodb-api-enable-mdl[={OFF|ON}] Deprecated Yes System Variable innodb_api_enable_mdl Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value OFF Locks the table used by the InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to create a PRIMARY KEY; use ALTER TABLE instead. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. Changing a column's blob part size must be done using a copying ALTER TABLE; this operation cannot be ...
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
The TABLESPACE option can be used with ALTER TABLE to move tables between general tablespaces, file-per-table tablespaces, and the system tablespace. Moving Tables Between Tablespaces Using ALTER TABLE ALTER TABLE with the TABLESPACE option can be ... A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE ...