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/validate-password.html
This applies to the ALTER USER, CREATE USER, and SET PASSWORD statements. Note For statements that assign or modify account passwords (ALTER USER, CREATE USER, and SET PASSWORD), the validate_password capabilities described here apply only to ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
(This is another reason you might wish to force MySQL to use the temptable algorithm by specifying ALGORITHM = TEMPTABLE in the view definition.) You can use DROP TABLE or ALTER TABLE to drop or alter a table that is used in a view definition. No ...
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. When ...In the absence of either clause, the account is created in an unlocked ...
https://dev.mysql.com/doc/refman/8.0/en/charset-column.html
If you use ALTER TABLE to convert a column from one character set to another, MySQL attempts to map the data values, but if the character sets are incompatible, there may be data loss. Every “character” column (that is, a column of type CHAR, ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
Tables can be converted from utf8mb3 to utf8mb4 by using ALTER TABLE. Otherwise, you should be able to convert your tables from utf8mb3 to utf8mb4 without problems, using ALTER TABLE as described previously. This section describes issues that you ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
CHECK TABLE is supported for partitioned tables, and you can use ALTER TABLE ... CHECK PARTITION to check one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of ...option: ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-concurrent-ddl.html
DDL operations that are not permitted during a cloning operation regardless of the clone_block_ddl setting include: ALTER TABLE tbl_name DISCARD TABLESPACE; ALTER TABLE tbl_name IMPORT TABLESPACE; ALTER INSTANCE DISABLE INNODB REDO_LOG; . Prior to ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
By default, MySQL automatically grants the ALTER ROUTINE and EXECUTE privileges to the routine creator. MySQL stores the sql_mode system variable setting in effect when a routine is created or altered, and always executes the routine with this ...By ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
An NDB tablespace to be dropped must not contain any data files; in other words, before you can drop an NDB tablespace, you must first drop each of its data files using ALTER TABLESPACE ... mysql> CREATE TABLESPACE myts -> ADD DATAFILE ... DROP ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
The default definer of an event is the user who created the event, unless the event has been altered, in which case the definer is the user who issued the last ALTER EVENT statement affecting that event. MySQL Events are tasks that run according to ...