PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | [SESSION | @@SESSION. | @@] system_var_name } SET syntax for variable assignment enables you to assign values to different types of variables that ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-repuser.html
Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to connect. The user name is specified by the MASTER_USER option on the CHANGE MASTER TO command when ...You can choose to create a different account for each replica, or connect to the source using the same account for each ...
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/keyring-key-migration.html
--keyring-migration-user, --keyring-migration-password: The account credentials to use to connect to the running server. The user who invokes a server in key-migration mode must not be the root operating system user, unless the --user option is ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.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. If the binary log was written by a mysqld with ... The ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user account. = 'auth_string' syntax is not deprecated, but ALTER USER is the preferred ...= PASSWORD('auth_string') syntax is deprecated in MySQL 5.7 and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Note Users in the MySQL grant system are wholly independent from any operating system users under Windows. Finally, before trying to ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-user-by-current-bytes.html
The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads ...By default, rows are sorted by descending amount of memory ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
This applies to the ALTER USER, CREATE USER, GRANT, and SET PASSWORD statements, and passwords given as arguments to the PASSWORD() function. Note For statements that assign, modify, or generate account passwords (ALTER USER, CREATE USER, GRANT, and ...For CREATE USER statements, validate_password requires that a password be given, and that it satisfies the password ... The ...