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/privilege-changes.html
A grant table reload affects privileges for each existing client session as follows: Table and column privilege changes take effect with the client's next request. If the mysqld server is started without the --skip-grant-tables option, it reads all ...
https://dev.mysql.com/doc/refman/5.7/en/show-open-tables.html
SHOW OPEN TABLES output has these columns: Database The database containing the table. Name locking is used for operations such as dropping or renaming tables. SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. LOAD DATA interprets all fields in ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
The plugin ignores files that have been renamed manually and do not match the pattern, and files that were encrypted with a password no longer available in the keyring. The audit log plugin supports functions that provide an SQL interface for ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME USER, CREATE (all forms except CREATE TABLE ... The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
In this case, remove or rename the data directory and try again. After MySQL is installed, the data directory must be initialized, including the tables in the mysql system database: For some MySQL installation methods, data directory initialization ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
Once this limit is exceeded, you must rename or remove the file before it is possible to execute any additional DDL statements. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
This function was renamed to JSON_ARRAY_APPEND() in MySQL 5.7.9; the alias JSON_APPEND() is now deprecated in MySQL 5.7, and is removed in MySQL 8.0. The functions in this section modify JSON values and return the result. JSON_APPEND(json_doc, ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
The decrypted file should display on the console: $> openssl rsa -in key.pem.new -passin file:password.txt Remove the original key.pem file and rename key.pem.new to key.pem. Note The keyring_okv plugin is an extension included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-crash-recovery.html
It ends the repair stage by removing the old .MYD file and renaming the new file to the original file name. This section describes how to check for and deal with data corruption in MySQL databases. If your tables become corrupted frequently, you ...