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/load-data.html
With user variables, the SET clause enables you to perform preprocessing transformations on their values before assigning the result to columns. User variables in the SET clause can be used in several ways. User variables cannot be used when loading ...By default, the server interprets the file contents using the character set indicated by the character_set_database system ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-migration.html
--keyring-migration-user, --keyring-migration-password: The account credentials to use to connect to the running server. The user a server in key-migration mode runs as must have permission to read and write any local keyring files, such as the data ...Pausing keyring operations during an online migration is accomplished by connecting to the running server and setting its global keyring_operations system variable to OFF before key copying and ON after key ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
On all platforms, MySQL Workbench is available and offers the ability to manage user accounts (see Chapter 29, MySQL Workbench ). Installation using the macOS installer generates an initial random password, which the installer displays to the user ...A password may already be assigned to the initial account under these circumstances: On Windows, installations performed using MySQL Installer give you the option of assigning a ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
As a result, it is possible to create the account and set its password without naming the plugin explicitly: CREATE USER 'sha256user'@'localhost' IDENTIFIED BY 'password'; Another consequence of setting default_authentication_plugin to ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
keyring-migration-user: User name for connecting to running server for key migration. binlog_group_commit_sync_delay: Sets number of microseconds to wait before synchronizing transactions to disk. binlog_group_commit_sync_no_delay_count: Sets ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } ...A ...
https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-statement-type.html
These views summarize informaion about statements executed, grouped by user and statement type. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host ...By default, rows are sorted by user and descending total ...
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html
One benefit of having a set of default keys is that it gives applications a way to check for the existence of encrypted column values, without giving the end user the right to decrypt those values. This function is the SQL interface to the algorithm ...For this to work, the user must have the SUPER ...The size penalty for storing the hex string in a CHAR column is at least two times, up to eight times if the value is stored in a column that uses the ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option file after the global option file but (on Unix) before the user option file. --user=user_name, -u user_name Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html
Linux users can use the libtcmalloc_minimal.so included in binary packages by adding these lines to the my.cnf file: [mysqld_safe] malloc-lib=tcmalloc Those lines also suffice for users on any platform who have installed a tcmalloc package in ...