PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
To remove it, execute the following statements: DROP TABLE IF EXISTS mysql.audit_log_user; DROP TABLE IF EXISTS mysql.audit_log_filter; UNINSTALL PLUGIN audit_log; DROP FUNCTION audit_log_filter_set_filter; DROP FUNCTION ... This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/backup-methods.html
For this statement, the output file cannot already exist because permitting files to be overwritten constitutes a security risk. If your replica is replicating LOAD DATA statements, you should also back up any SQL_LOAD-* files that exist in the ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
Installing SHA-2 Pluggable Authentication In MySQL 5.7, the caching_sha2_password plugin exists in client form. The discussion here assumes that an account named 'sha2user'@'localhost' exists on the MySQL 8.0 or higher server. MySQL provides two ...
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
To require use of encrypted connections by a MySQL account, use CREATE USER to create the account with a REQUIRE SSL clause, or use ALTER USER for an existing account to add a REQUIRE SSL clause. To require use of encrypted connections by a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
Converting an Existing Table To convert a non-InnoDB table to use InnoDB use ALTER TABLE: ALTER TABLE table_name ENGINE=InnoDB; Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. If you have MyISAM tables ...
https://dev.mysql.com/doc/refman/5.7/en/crashing.html
Because MySQL works for many people, the crash might result from something that exists only on your computer (for example, an error that is related to your particular system libraries). Each MySQL version is tested on many platforms before it is ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
An error occurs if you try to add a new row with a key value that matches an existing row. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
Such an index is created on the referencing table automatically if it does not exist. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent.
https://dev.mysql.com/doc/refman/5.7/en/create-temporary-table.html
This means that two different sessions can use the same temporary table name without conflicting with each other or with an existing non-TEMPORARY table of the same name. (The existing table is hidden until the temporary table is dropped.) CREATE ...