PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
That is, it places constraints on CREATE USER and ALTER USER statements with respect to multifactor authentication. CREATE USER and ALTER USER have syntax enabling multiple authentication methods to be specified for new accounts, and for adding, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-syntax.html
Trying either to create a temporary table that uses the NDB storage engine or to alter an existing temporary table to use NDB fails with the error Table storage engine 'ndbcluster' does not support the create option 'TEMPORARY'. Attempting to create ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
To refer to the PAM authentication plugin in the IDENTIFIED WITH clause of a CREATE USER statement, use the name authentication_pam. For example: CREATE USER user IDENTIFIED WITH authentication_pam AS 'auth_string'; The authentication string ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
(This constraint rules out the use of the keyring functions for manipulation of instance-wide keys, such as those created by InnoDB to support tablespace encryption.) To enable multiple users to perform operations on the same key, “wrapper” ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-example.html
You should include such options as necessary to enable client programs to connect to the MySQL server. Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash recovery. Assume also that the ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-index-stat.html
To force them to be created (or updated if they already exist), invoke ndb_index_stat with the --update option, or execute ANALYZE TABLE on the table in the mysql client. --sys-create Command-Line Format --sys-create Create all statistics tables and ... ndb_index_stat provides per-fragment statistical information about indexes on NDB ...
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 ... In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE ...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/stored-objects-security.html
Creating a stored object with a nonexistent DEFINER account creates an orphan object, which may have negative consequences; see Orphan Stored Objects. If a definition omits the DEFINER attribute, the default object definer is the user who creates it. Orphan Stored Objects An orphan stored object is one for which its DEFINER attribute names a nonexistent account: An orphan stored object can be created by specifying a nonexistent DEFINER account at object-creation ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. By default, triggers that have the same ...